PROBLEM with ACCESS 2016 and properties missing

Frank Freese
Frank Freese used Ask the Experts™
on
Folks,
 
VBA provides a list of commands available for different objects and then the supporting properties for that command. For example, if I have this code:
TempID=Me.txtUserName and I am looking for the VALUE following the name here's what I get: TempID+Me.txtUserName. and VALUE does not show up.
However, if I type the word VALUE no problem. I don't understand what's going on.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Neil FlemingConsultant and developer

Commented:
Can you post your code? The example you give is a little unclear.

When you say you "type the word value" in particular, not sure what you mean.
John TsioumprisSoftware & Systems Engineer

Commented:
I am also a bit confused.
I guess that you want to make some concatenation
If this is the case then
Some variable = "VALUE : " & Me.txtUserName

Author

Commented:
I had a feeling it would difficult to put this in words.
CODEWHAT I was expecting that one of my code options on the text control would be to set the focus on a control when the form opens. I found out that txtUSERName.SetFocus is not an option?
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

Author

Commented:
Folks,
Basically, what I trying to do is when a form loads, set the focus of a text control box. Forget everything I have sent to you, please.

Author

Commented:
I forgot to mention. The form is a POPUP style if that makes any difference?
Software & Systems Engineer
Commented:
Something is wrong here...but i am not sure what...
To me it seems like txtUserName is not a textbox but another kind of control that mistakenly carries this name.
I am attaching a sample to see how i handle this
Database11.accdb

Author

Commented:
John,
I'm inclined to agree with you. I've done many times before but never experienced this problem. Thank for the sample and appreciate you hanging in there with me.
Frank

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial