Adding textbox.text to a string variable...

[MatthewGrace]

Thanks to anyone willing to help. Here is a simple block oferroneous code:

Private Sub Command19_Click()
Dim myString as String
myString = TextBoxName.Text


This produces an error "You can't reference a property or method for a control unless the control has the focus". Is there another way to gather the Text from that textbox programmatically?



Thanks
MG

[ItsMe]

You are wanting the .Value property

Me.TextBoxName.Value

[ipisors]

And I would just like to clarify. You can use .Text if that control does have the focus. Why would that ever be useful? If the .Value property hasn't been updated yet...Like it won't if you haven't exited the control yet.

Also worth bringing up: You can use .Value if just referencing the value of a control. However, it's also good to disambiguate your Control names from their ControlSource names. For example, if your Controlsource field is called dtCreated, then call your textbox txtdtCreated (or something) - that way it's clear what you're coding. Because the underlying ControlSource table field won't have been updated yet, but the Control will.