Expression in Cond. Format not working

[pambroben]

I have a text box controlled by a hyperlink field in table Patient.

I would like the text box to change colour when encountering an "N" in field REG2012 of that table.

I have used Expression is [Patient]![REG2012]="N" but did not work.

Any assistance will be greatly appreciated.

Cheers,
Brodie

 

[vanceric]

Try Expression is [TextBoxName] Like "N"
Change TextBoxName to the name of the text-box you want to format.

 

[pambroben]

1. already tried that - still NOGO
2. the textbox name is REG2012 and is controlled by the 12FilePath field in same table (the hyperlink).

The textbox correctly shows the data in 12FilePath, but refuses to change colour according to the conditional formatting rule.

All I am trying to do is get the text box to display the contents of one field, while being conditionally formatted by another field.

 

[pambroben]

Solved it!.. I took out the [TableName] and left only the [FieldName] and it works!