Visible fields problem

[Guest]

I have a form that has a textbox that I would like visible only if a chkbox
is true.
It toggles from visible to not visible, but it changes all the records . I
would like it to toggle only the current record.
can you help please?
Thanks, Edward Keith

 

[missinglinq via AccessMonster.com]

Is this a continuous form, datasheet or single form? What code are you using
to bring this about, and where do you have the code placed?

I have a form that has a textbox that I would like visible only if a chkbox
is true.
It toggles from visible to not visible, but it changes all the records . I
would like it to toggle only the current record.
can you help please?
Thanks, Edward Keith

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Jacob]

Edward,

Look like you are talking about a continious form. If this is the case,
you cannot hide the text box in one record only. However, you can use
Conditional Formatting and set the fore color to be the same as the
back color in which case the *data* in the text box will not be
visible. Be ware that whilst the data is "invisible" it *can* still be
changed.

Regards/JK