Continuous Form

[Jn88]

Let say I have a Continuous form what displays balances and I wont that if the balance is 0 a image or a label should be visible and if not not, so by a normal form this is no problem I put code in the current event but by the a Continuous form all the labels change not only from this record?

Jn88

 

[PaulF]

if you are talking about one TextBox in the detail section of the form, then you can accomplish this by using 2 TextBoxes that are the same size, each with it's Back Style set to Transparent, one with 0 for the Fore Color and the other with 255 for the Fore Color. For the Control Source for the one with 255 as the Fore Color use
IIf([Balance] = 0, [Balance],"&quot
for the other text box use
IIf([Balance] = 0, "", [Balance])

Place these TextBoxes one on top of the other and open the form.

PaulF