Help needed with conditional formatting

[Luke Storer]

I have read the Access Help page before posting here

I have a text box called TxtCharRemain formatted as general number
It displays how many more characters can be typed into a text box named TxtActionTaken
I want the contents to appear in red when TxtCharRemain is less than 1 (0 or negative)

but it doesn't it only displays 0 in red then all negative numbers in black

I have tried setting default color as red and formatting the text box to display in black when value is between 1 and 200 and this doesn't work as values less than 100 appear red and negative numbers appear red or black

any ideas?

 

[WayneRyan]

Luke,

Hard to say without seeing it, but I don't think it's treating your textbox
as a number.

Try referencing it with CLng(TxtCharRemain) and see if that works.

Wayne

 

[Luke Storer]

not sure where in the conditional formatting I'm supposed to use Clng(TextCharRemain) so have made a copy of the form.

where can is it best to upload .zip to?

[edit]
http://www.filefactory.com/file/f4975d/
[/edit]