What could cause the assignment of a default value to a text box or combo box in Access XP VBA to give a #Name? error? For example, I have a very simple declaration of

Me.txtMyField.DefaultValue = "Whatever"

When I open the form, instead of the default I specified, I'm getting the #Name? error in the text box. I'm getting the same error in a combo box in another form. Both syntaxes are quite simple and they are correct.

What gives?


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

It seems .DefaultValue only works on a bound textbox not an unbound one.

Cheers Ray

Actually, my fields are bound. Here is how this is solved. It makes no sense to me, but it works.

Me.txtMyField.DefaultValue = "'Whatever'"


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

<quote>
Actually, my fields are bound. Here is how this is solved. It makes no sense to me, but it works.

Me.txtMyField.DefaultValue = "'Whatever'"
</quote>

Um... how is the solution different than the original problem code?


I'm having a similar problem. I have a bound field on a form, and I'm just trying to set its DefaultValue from the form's open event code:

Me.ProcurementTitle.DefaultValue = "hi"

This gives me #Error instead of "hi" when I open the form. Funny thing is I'm doing exactly the same thing on another form with another bound control and it works fine. Also, if I set DefaultValue to "hi" in the property sheet instead of from code, it works fine (I get "hi" instead of #error). Anyone know what's going on?

 

Sorry, stupid me I missed the single quotes.

Figured it out. In my case, the main problem was that my string data had a bunch of trailing spaces, so I had to use trim.

For the rest of you, the solution is to concatenate the double quotes in code. I have no idea when the double quotes are and and are not required, since I am doing it both ways in separate places with no obvious differences.

This is what worked for me:
Me.ProcurementTitle.DefaultValue = Chr(34) & Trim(strResult) & Chr(34)