constantly needs focus

[Dazza666]

Hi,



I can't see why almost everytime I reference a property of an object through through an event (for example "on click") I get an error requiring me to set the focus to the object first, normally I can do this by adding object.SetFocus first however i'm now trying to append the text from a textbox as below, to a string and it just errors out because of the last element me.notes.text stating the object needs focus.

I've worked mildly with access in the past and I don't remember needing to give an object focus for almost every single action! I'm running access 2013, any help would be appreciated

MyItem.Body = "Request Title" & vbCrLf & vbCrLf & DLookup("RequestTitle", "MaintenanceRequest", "ID=" & Me.RequestID) & vbCrLf & vbCrLf & "Request Description" & vbCrLf & vbCrLf & DLookup("RequestDescription", "MaintenanceRequest", "ID=" & Me.RequestID) & vbCrLf & vbCrLf & "Escalation Notes:" & vbCrLf & vbCrLf & Me.Notes.Text

[RuralGuy]

In Access, a control usually needs the focus in order to use the .Text property which is why we use the .Value property instead which does not need the focus.

[Dazza666]

In Access, a control usually needs the focus in order to use the .Text property which is why we use the .Value property instead which does not need the focus.

That's it, that's sorted it out, thanks for the help and taking the time to explain, really appreciate it.

[pbaldy]

RG has already resolved your issue, but if you're bored and want more info:

http://www.baldyweb.com/ValueText.htm

[RuralGuy]

Excellent! Glad we could help.