Conditional Formatting in Access 97?

[mohsinhq]

Is it possible to format fields conditionally in access 97?

I am trying to change the font colour and font weight based on the value in the field?

Thanks in Advance

 

[ColinEssex]

In the OnCurrent event of the form put

If Me.YourFieldName = "Something" Then

Me.YourFieldName.ForeColor = VbRed

Else

Me.YourFieldName.Forecolor = VbBlue

End If

Col

 

[mohsinhq]

thanks alot for that. one other question..

ive tried making the field bold by:

if me.txtFieldname > 0 then

Me.txtfieldname.fontbold = true

end if

without any luck?

any ideas?

 

[ColinEssex]

I've just tested this code and it works fine when I scroll from record to record

If Me.FirstName = "John" Then
Me.FirstName.ForeColor = vbRed
Me.FirstName.FontBold = False
Else
Me.FirstName.ForeColor = vbBlue
Me.FirstName.FontBold = True
End If

Not sure why yours is not working

Col

 

[mohsinhq]

colin,

could it be because my form is showing records in continuous form view?