Datasheet form has #NAME? in field

[Marc]

I can't seem to figure this one out. I have a form that is built on a
query. One of the fields is a calculated IIF statement. When I view
the form as a "single form," this field is correct for each record.
However, when I switch to "datasheet" the column for this field becomes
filled with #NAME?.

Any thoughts?

 

[G. Vaught]

My guess is that when in datasheet view, the code behind the form can not
execute as it does when in single form. What happens when you go into
Continuous Form?

 

[Guest]

Hi Marc,

This sounds strange, indeed. Here is a KB article that may be helpful:

ACC2000: Troubleshooting Tips for Error Values
http://support.microsoft.com/?id=209132

Note: Applies to Access 2002 and 2003 as well.

You might want to verify that you are not using any reserved words for the
names of fields, objects or controls. Try downloading Access MVP Allen
Browne's "Database Issue Checker Utility" or consult his list of reserved
words here:

http://allenbrowne.com/AppIssueBadWord.html

Are you using the IIF statement in your query, or in the control source of a
textbox on your form?


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Marc]

Thank you both for the quick response. Don't ask me how, or why, but
when I went into the database to check on the questions you had raised,
it works just fine now.

Should this problem arise again, I will take a look at these links.

Thanks so much.