Display actual values instead of #'s

[Kowalski]

Hi
Are there a way (in Access 2010), that the text boxes will not display #### for values that does not fit into the textbox?

I've got some reports where there can be quite large values in, and then the textboxes display ##### for these large values. I would rather have it to display what can, even if it means that the left most digits might not appear.

 

[Galaxiom]

This should only happen with number field types and is designed to alert the user lest they use a truncated number so it is a bit dangerous to turn it off.

I expect it is this setting:

Access Options - Current Database - Check for truncated number fields.

 

[Kowalski]

That's it - thanks.