Access 2000 db in Access 2007- formfield contains formula or somet

[Redmond Forest Trust]

The form field should view/show/contain a # like: 117054
however, it shows: 1.17054E+05

Using Access 2000 or 2003 - it was showing the correct number.

When you print preview it looks fine. It prints the correct form field data
too.

The databse is still in 2000 format. Everything else seems to be OK.

help?

 

[Allen Browne]

Open the form in design view, and clear the Format property of the text box.
Also, make sure the text box is wide enough to display the large number.

If that doesn't solve it, and the text box is bound to a field in a table,
open the table in design view, and clear the Format property of the field.

It sounds like the format is set to Standard, or a custom format that shows
the value as a power of 10.