asked on

PROBLEM with ACCESS 2016 and properties missing

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.

Neil Fleming

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 Tsioumpris

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

Frank Freese

ASKER

I had a feeling it would difficult to put this in words.

WHAT 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?

Frank Freese

ASKER

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.

Frank Freese

ASKER

I forgot to mention. The form is a POPUP style if that makes any difference?

ASKER CERTIFIED SOLUTION

John Tsioumpris

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Frank Freese

ASKER

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