Can Conditional Format applied for textbox visible property?

[LittleNick]

Greeting,
Using Conditional Format, we can color a record when an expression is met. What I need to do is very similar situation except when the expression is true I need a textbox to be visible for that row. Visually:

Mary Smith 11234567 $40.50 not checked(chkbox)
John Dow 22344566 $30.00 not checked
Brandy Jones 33333445 $35.00 checked 12/04/09 (date textbox apprears to allow to enter a date).

Thanks for helps

 

[dhookom]

I think the only choice you have if this is a continuous form is to set the text and background to the same color.

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

... or you can disable the control giving it that [blue]disabled look.[/blue] However I believe you'll find [blue]dhookom's[/blue] post more appealing.

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[LittleNick]

Thanks To Duane and TheAceMan1 for your replies. I use Duane's suggestion and works good.
Thanks again.

Happy Holidays!!!