<div>
thanks, <br />
<br />
I did Find a work around, &nbsp;unfortunately, I can't remember what i did, but it working.
</div>


thanks,

I did Find a work around,  unfortunately, I can't remember what i did, but it working.

<div>
<div class="content wysiwyg-content">
I have a text box on a form that calls a function in the Control Source that i want to pass the text box's name so within the function i can set backcolor, forecolor...<br />
<br />
I don't want to have to hard code the text box's name within the call to the function.<br />
<br />
=ELookup(??currenttextbox.<wbr />name??, status)<br />
<br />
Public Function ELookup(textboxname as ?control?, Status As String)<br />
If Status = &quot;x&quot; then<br />
&nbsp; &nbsp;textboxname.forecolor = vbred<br />
Else<br />
&nbsp; textboxname.forecolor = vbGreen<br />
End Function<br />
<br />
would i also have to pass the form name within the function?
</div>
</div>


I have a text box on a form that calls a function in the Control Source that i want to pass the text box's name so within the function i can set backcolor, forecolor...

I don't want to have to hard code the text box's name within the call to the function.

=ELookup(??currenttextbox.name??, status)

Public Function ELookup(textboxname as ?control?, Status As String)
If Status = "x" then
   textboxname.forecolor = vbred
Else
  textboxname.forecolor = vbGreen
End Function

would i also have to pass the form name within the function?

Access 2010 need to know how to reference the text box name from Control Source

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.