Am I stupid, or.....

[MattLewis]

I'm having trouble getting the value of a TextBox in VBA code. Either I'm stupid or Access is utterly ridiculous.



Ultimately, I'm trying to open a form using a where clause which is built based on the current value of a TextBox. The TextBox which has the string I want has a ControlSource set and it changes automatically based on which record is currently selected on the containing form.

DoCmd.OpenForm FormName:="JobDetails", WhereCondition:="JobRef = '" & JobID.Value & "'"

I've narrowed the problem down to the fact that the current value of the text box is (apparently) not accessible at run-time. Here is an example (name of TextBox is JobID):

MsgBox Me.JobID.Value

The string returned by JobID.Value is a string of 8 question marks "????????". I also tried:

MsgBox Me.JobID.Text

That was an error because JobID didn't currently have focus. This is cheesy because why does it EFFING matter what has focus? Then I tried:

MsgBox Me.JobID

That also returns 8 question marks.

[ranman256]

You don't need the .value, me.jobID will give the value.
???? Could be a format issue.
the text box doesn't need the focus,BUT the form with it does.

[MattLewis]

.Value or Me.JobID, they are both returning something that renders as "????????". They should be returning a string and that string should be the value of what is currently in that TextBox, and it's not. Hence the problem. For example, if JobID was currently "123456", then the string returned by Me.JobID should be "123456"

To be clear, the TextBox is plain text with basic alphanumeric characters (no extended or UNICODE or anything weird like that). There should be no "format issue"

[pbaldy]

FYI, focus is required when referring to the Text property. What event is the code in? Can you attach the db here?

[MattLewis]

OK, After going through a bunch different tests, I've isolated the problem: The TextBox in question is bound to an AutoNumber with format of ReplicationID. If I re-create everything but with a long integer format (all other things the same), it works.

So, moral of the story: Access VBA doesn't return the expected string for TextBoxes bound to an AutoNumber of format ReplicationID