How to code a textbox to display an empty field

[RexesOperator]

I am currently using conditional formatting that changes the text displayed to white, based on the value of the field.

Is there a more elegant way of doing this in code?

For example if a value is <0 I want the text box to be null or empty. I have had success with string values, such as IIF([Textbox] = "a", ""), but this doesn't work for numeric values.

 

[gemma-the-husky]

it should do

IF [Textbox] < 0 then
do something
else
do something else
end if

 

[RexesOperator]

I guess my question should be how do I get a textbox holding numeric data to display nothing based on the content of the field, other than using conditional formatting?

ie if the value is -99 I want the report to show a blank rather than the -99.

 

[Alisa]

I am currently using conditional formatting that changes the text displayed to white, based on the value of the field.

Is there a more elegant way of doing this in code?

For example if a value is <0 I want the text box to be null or empty. I have had success with string values, such as IIF([Textbox] = "a", ""), but this doesn't work for numeric values.

Have you tried: IIF([Textbox]=-99,null) ?

 

[RexesOperator]

Absolutely brilliant! A thousand thankyous!

 

[Alisa]

Absolutely brilliant! A thousand thankyous!

I'm glad it worked.