Change value of bound subform textbox

[clunetta]

Hello,
I have a subform on a tab in the main form that is bound to a table. In the subform's detail section are two bound textboxes. If the value in the first textbox is 0 then the value of the second textbox needs to be "--" instead of the value of the control source (this will happen about 33% of the time). This seems like a simple problem, but I can't make headway. Could anyone please point me in the right driection?

Thanks,
Charlie

 

[TheAceMan1]

How are ya clunetta . . .

If the data type of the second textbox is numeric you'll get a type mismatch error!

See Ya! . . . . . .

Be sure to see thread181-473997

 

[clunetta]

Got it, and I feel like a dork. It was so simple I didn't think of it -- an Iif statement in the textbox's control source!