Conditional FontBold based on other control

[abusaif]

Good Morning,

I have 2 controls [Item] and [PCno], I want [Item]'s font to be shown bold if [PCno]'s value is null.

I tried this;

If (Me.PCno = "") Then
Me.Item.FontBold = True

Else
Me.Item.FontBold = False
End If



but nothing happens.

Kindly help.

[CJ_London]

suggest use conditional formatting rather than vba code which won't work as you expect in a continuous form.

If the form is single then you can use vba code - this is a simpler code

me.item.fontbold=nz(PCNo,"")=""

however it may not be working because the event you have put the code in may not be triggered.