text box displays #name?

[eddiec]

hi everyone,

I have added a new field to a table and added this field in the data source
of a form. I have also added a text box to the form and have bound the text
box to the new field. When I open the form, however, I just get #name? in
the text box.

This is not a NULL problem, I have tried using iif to trap NULLs and have
also tried setting the default value of the new field to 0 but still no
luck.

HELP!

TIA

EddieC

 

[Mike Painter]

hi everyone,

I have added a new field to a table and added this field in the data
source of a form. I have also added a text box to the form and have
bound the text box to the new field. When I open the form, however, I
just get #name? in the text box.

What is the name of the field?
Did you select the field name from the dropdown or type it into the source?
It might be mispelled.
If you use spaces in field names make sure you have the correct number.