Hide textbox on a record - Continuous form

  • Thread starter Thread starter Sky
  • Start date Start date
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
 
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
Click to expand...

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
 
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
Click to expand...

It works. Thanks
 
It works. Thanks
Click to expand...

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
 
Back
Top