Problem populating textboxes from VBA

[Mark]

I am attempting to populate several textbox controls
from VBA code. With each attempt, I get the following
error:

"The macro or function set to the BeforeUpdate or
ValidationRule property for this field is preventing
Microsoft Acess from saving the data in the field."

Naturally, I have no BeforeUpdate events or
validation rules defined for these fields. If I set
the error handler to "resume next," one textbox
is populated but the rest are not.

I have seen numerous references to this problem in
Google, but no solutions. Any suggestions?

Thanks
-Mark

[Mark]

Hmm. . .I solved it by writing to the textboxes' "value" property
rather than their "text" property.

Someday I'll have to read up on why that is the case.

[Allen Browne]

Thanks for posting your solution Mark.

In pure VB, Text is the default property for controls, but it is different
in Access. Being data orientated, Value is the default property in Access.
Text applies only while the control has focus, and refers to the text in the
control. For example, while you are entering a date, the Text might be:
12/13/
but that would never be accepted as the Value because it cannot be
interpreted as a date.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mark" <no****@thanksanyway.org> wrote in message
news:Hq********************@speakeasy.net...

Hmm. . .I solved it by writing to the textboxes' "value" property
rather than their "text" property.

Someday I'll have to read up on why that is the case.