conditional formatting of a textbox on a continuous subform

[Mark Kubicki]

I have a continuous subform with (3) fields displayed (in 3 controls: 2
checkboxes, one enabled, one not), and a textbox
I would like the "locked" property of the text box, determined by the value
of the locked checkbox (it's status is set through some VBA code elswhere in
the project...)

-on a record-by-record basis

is this possible?

thanks in advance,
mark

 

[Guest]

Why not have it locked by default?
In your form's OnCurrent event, you could check the value of the checkbox
and unlock the control if appropriate.

Since this event will fire if a user clicks on any record, it may do the
trick.

Steve

 

[Mark Kubicki]

some of the records are always locked, some are always not locked (it
depends whether the information may or may not be edited)

I would like to user to have a visual clue as to which record can or cannot
be... without having to click on each record to see if it unlocks

however, i might (although not ideal) be able to work in reverse: OnCurrent,
check values, and then flag a msgbox "you can't touch me!!" if the record is
uneditable...

thnx




, or if it is a user entere

 

[Guest]

some of the records are always locked, some are always not locked (it
depends whether the information may or may not be edited)

I would like to user to have a visual clue as to which record can or cannot
be... without having to click on each record to see if it unlocks

however, i might (although not ideal) be able to work in reverse: OnCurrent,
check values, and then flag a msgbox "you can't touch me!!" if the record is
uneditable...

thnx




, or if it is a user entere