Date fields change to pound signs

[RichO]

Just switched from Access 2000 to 2010 and now on many forms and reports where dates are displayed, you see ###### instead. I realize that widening the field fixes this but there are a lot of forms and reports in this database to go through and change all of them.

Is there a setting somewhere to have the date fields display properly even if the text doesn't completely fit in the box?

 

[spikepl]

It probably has to do with fonts - default font changed at some stage. So you have to change the fonts to whatever they were in A2000.

 

[RichO]

I just checked my old version of the database (mdb file) and the font name and size is exactly the same in each of the forms/reports that this happens in.

 

[Galaxiom]

File > Options > CurrentDatabase > Check for Truncated Number Fields

They really won't be displayed properly if they don't fit but at least they will display.

 

[RichO]

File > Options > CurrentDatabase > Check for Truncated Number Fields

That did the trick. Very little of the date field is cut off, almost a trivial amount. Thanks