Controls showing ######

[Gkirkup]

I have a big application with 100 or more forms. We have just upgraded to Access 2010, programs and data. Now we have many controls, which were fine in 2003, displaying as #####. Is there an option to turn that off? I know I can expand the controls, but sometimes that is very difficult.

Robert

 

[CJ_London]

You can't turn it off but if you can't increase the size of the control, make the font smaller?

 

[Gkirkup]

So what does the global setting 'Check for truncated number fields' do?

Robert

 

[CJ_London]

never used it - why not try yourself!

 

[missinglinq]

So what does the global setting 'Check for truncated number fields' do?

When it's ticked numbers appear as "#####" when the column isn't wide enough to display the entire number. If it's not ticked you only see part of the number and have to scroll to see all of it.

As CJ suggested, either widening the Control, if possible, or changing fonts is probably the way to go.

Linq ;0)>