trying to make something bold if it meets a condition (1 Viewer)

[asp_learner]

Why is this code not working. The program accepts the code but the text is not coming out bold.

Thanks,
Eva

If [Text357] > [Text406] Then
Me![Text406].FontWeight = ExtraBold
Else
Me![Text406].FontWeight = Normal
End If

 

[Howlsta]

Which event is the code in?

Also you could do what Rich suggested to me in the previous post.
Select the control in design view.
Select format on the toolbar.
select coditional formatting
Follow the rest of the instructions.
This way is easier anyway.

HTH

Rich

 

[asp_learner]

Thanks.

I did not notice your post when I posted my question. I hope I will get this to work now.

Again many thanks,
Eva

 

[Bob the Sheep]

A possible reason as to why it is not working is because it does not know they are values.

I am assuming that you are comparing numbers if so you could always try the following:

If val([Text357]) > val([Text406]) Then
Me![Text406].Font.bold = true
Else
End If

Hope this helps

Bob the Sheep