setfocus and accessing a text box

[swarv]

All,

I have a text box on a form and I would like the following code to read it

 userloggedon = Forms.frm_homepage.user_id.Text

This is fine if the box is visible, if the box isn't visible then it wont read it.
I would like the box not visible to the user but still be able to read it.
Is this possible?

Thanks

Martin

 

[missinglinq]

That's because Text requires that the control have focus, and you can't set focus to a control that's not visible!

Repalce

userloggedon = Forms.frm_homepage.user_id.Text

with

userloggedon = Forms.frm_homepage.user_id.Value

Because Value is the default property of textboxes, you can actually simply use

userloggedon = Forms.frm_homepage.user_id

In Access VBA, as opposed to straight Visual Basic, the Text property is very seldom used.

 

[RuralGuy]

Don't use the .Text property. Use the .Value property, which is the default property and need not be specified.
userloggedon = Forms.frm_homepage.user_id
...or...
userloggedon = Forms.frm_homepage.user_id.Value

 

[swarv]

many thanks guys - that helps lots. I'll just edit some code.

cheers

 

[missinglinq]

Glad Allan and I could help!