Table data is all screwed up...????

[Jacqueline]

I am looking at an Access2000 database...the forms show
all 2500 records with all the information in the
fields...BUT I just opened all the tables for each form
and in the field names and in each record's field I see
jibberish...or symbols.
When I look at the table in design view...all the field
names are fine...

And the real funny thing is...I just tried copying an
example of the jibberish and posting it here in this
message...and when I paste it...I see the correct data
(not the jibberish)

What the F*#! is up with that...was some property set by
accident by the data enterer that changed what you see in
the tables to this crap!??

Any help greatly appreciated!

 

[Jacqueline]

I figured out that the font for the table's was somehow
changed...when I picked another it was fine...

Have NO idea how that happened though...

 

[Marylou]

Your field width may be compressing the data. Try expanding the width.