Hide textbox on a record - Continuous form

S

Sky

Hi,

I need to hide a textbox in a continuous form, but the problem is that
when I use a txtClient.Visible = False, I got all the textboxes from
all the rows hide, and I just want to hide the current row...

Anyone has a solution?

Thanks
 
J

John W. Vinson

Hi,

I need to hide a textbox in a continuous form, but the problem is that
when I use a txtClient.Visible = False, I got all the textboxes from
all the rows hide, and I just want to hide the current row...

Anyone has a solution?

Thanks

Use Conditional Formatting. Open the form in design view, select the textbox,
and select Format from the menu.

This gives you the ability to change the color (but not, alas, the Visible
status) of the control in a data-dependent manner. The trick is to set the
forecolor and backcolor to the same color if you want it hidden. The Beatles'
White Album had visible texture but your textbox needn't <g>...
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
S

Sky

Use Conditional Formatting. Open the form in design view, select the textbox,
and select Format from the menu.

This gives you the ability to change the color (but not, alas, the Visible
status) of the control in a data-dependent manner. The trick is to set the
forecolor and backcolor to the same color if you want it hidden. The Beatles'
White Album had visible texture but your textbox needn't <g>...
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

It works. Thanks
 
S

Sky

It works. Thanks

The idea works.

I used conditional formatting and then I changed the forecolor and
backcolor to the same color of the form background.

Something like:
Expr: [Type_of_Client]="Gold"

Thanks for your precious help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top