Show/hide control on "continuous forms" form view

[Guest]

I have an MS-Access form with a textbox in the detail section. I want to
show/hide that textbox for *that row only* depending on a value in a control
elsewhere in that row.

I've played around with a few different events, but have only been able to
have Access show/hide the control on all the rows.

I must be missing something obvious…any suggestions?

 

[Todd Shillam]

Rob,

Got an idea here--not sure if it will work. However, you might be able to
create an bound text box to 'conceal your textbox that you would like to
hide (you've got me wondering).

Then you could use the 'AfterUpdate' event of the control you would like to
'fire' the event to control the visibility of the text box. I'll be giving
this a try myself--I'll let you know what I find out.

Best regards,

Todd

 

[Todd Shillam]

Rob,

Well...my initial attempt didn't go so well; however, I did find another web
resource that appears to address the same topic you have wrote about:

http://www.tek-tips.com/viewthread.cfm?qid=951462&page=6

Best regards,

Todd

 

[Allen Browne]

You cannot selectively make items invisible on different rows of a
continuous form.

However, you can simulate it by using Continuous Formatting, e.g. by setting
the ForeColor and BackColor to the same thing.

If you need an example, I think Stephen Lebans had one at www.lebans.com

 

[Guest]

Thanks for your efforts Todd, I'll check it out.
Rob