Need help hiding 0.00 value in datasheet view

[erick-flores]

Hello all

I am having a lil problem to display my data in datasheet view. I know
you can not have more than 3 Conditioanl Formating. So I am trying a
way around to eliminate one of my current CF so I can add another one
but at the same time keep the other CF.

My question: How do I HIDE (I dont want it to display) a field in
datasheet view if the value is = 0.00 without using conditional
formating, in other words using VBA code.

Thanks in advance...

 

[Guest]

Use this as the format property of the text box you want to format:
"#.00;(#.00);#"

 

[erick-flores]

Thanks...works fine