Show or Hide textbox/Lable based on checkbox for each record

[naeemahmad]

Hi Guys,

Im having a brain-fart.. and cant seem to remember an efficent method to accomplish this..

I need to have a continous subform show or hide a textbox or label based on a recorsd checkbox. I cannot use the 'On Current' event becuase this is only triggered when a user clicks onto the record.

for example:
The database has a true/false checkbox field to show record status.
so when the user enters (loads) the form.. each record will either show (make visible) a textbox or label that says "COMPLETED" or "PENDING"

this needs to be done without the user having to click on each record to see the status.. hence 'On Current' even will not work for me.

Any help / guidence to aproach this is very much appericiated!



Thanks as always.. just dont have enough coffee in me .. yet.. to remember how I use to do this before..

Naeem~

[pbaldy]

Try Conditional Formatting on a textbox. You can't do Visible, but you can set the font the same as the backcolor to get the same effect.

[naeemahmad]

Thanks for the reply. Actually conditional formating also limits what I can do with controls..The solution I used was 'On Paint' event of the record detail itself.

heres how I approached the issue.

Private Sub Detail_Paint()
If Me.MAINT_LOG_STATUS.Value = True Then
Me.lblSTATUS.Caption = "COMPLETED"
Else
Me.lblSTATUS.Caption = "PENDING"
End If
End Sub

Appericiate the help, but just couldnt remember how I did it before... getting to old for this! LoL

[pbaldy]

No problem. Using code, I'd use the detail format event, unless you're using the new Report view. If memory serves, the paint event doesn't fire in Preview or Print.