must trick to backColor textbox (1 Viewer)

[24sharon]

I open form and get parameter in the openArgs

I have a tabular Form
and I want change the color if the ID is aqual.

for example:
I open the form like this:

DoCmd.OpenForm "frmMessageShow", , , "fID=" & Me.fID, , , Me.AssighmentId
[the Me.AssighmentId is the openArgs]

I want in the second form to color the textbox if AssighmentId = me.openargs

I try do it:
If Me.AssighmentId = Me.OpenArgs Then
AssighmentId.BackColor = vbRed
End If

and its not work

is there is an option to do it?

thanks!

 

[Tsango]

Sorry mate, but I don;t really understand what you are trying to achieve here.

Is AssighmentID a text box???

From what I can tell you checking the Value parameter of the AssighmentID text box to see if it is equal to the passed value and if it is then you want to change the back colour to red.

Is that correct?

 

[24sharon]

I know my english not good, but I success do it.


I did conditional formatting with expression
[AssighmentId]=[text39]

and in the page load I wrote:


If Not IsNull(Me.OpenArgs) Then
Me.Text39 = Me.OpenArgs
End If

that work great.
thanks!