Hide Text Box Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a text box that references and calculates:

=
  • .[column](1,1)/
    • .[column](1,0)

      The user must select a month before the List populates with data, so before
      selecting the month, the text box with the reference above displays "Error".
      I was fiddling with the Nz function trying to figure out how to suppress that
      error. Can anybody help?
 
You could make the control invisible and then make it visible only when the
user selects a month.
 
When I try to do what you suggest I get "you can't hide a control that has
the focus".

Rob Oldfield said:
You could make the control invisible and then make it visible only when the
user selects a month.


Ray S. said:
I have a form with a text box that references and calculates:

=
  • .[column](1,1)/
    • .[column](1,0)

      The user must select a month before the List populates with data, so before
      selecting the month, the text box with the reference above displays "Error".
      I was fiddling with the Nz function trying to figure out how to suppress that
      error. Can anybody help?
Click to expand...
Click to expand...
 
Yes. Exactly as the error says, you can't make a control that has the focus
invisible. So you would just use me.anothercontrol.setfocus to shift the
focus elsewhere.

Having said that, I'd suggest that in your position just to leave the
control invisible in normal design view, and then switch it to visible when
required.


Ray S. said:
When I try to do what you suggest I get "you can't hide a control that has
the focus".

Rob Oldfield said:
You could make the control invisible and then make it visible only when the
user selects a month.


Ray S. said:
I have a form with a text box that references and calculates:

=
  • .[column](1,1)/
    • .[column](1,0)

      The user must select a month before the List populates with data, so before
      selecting the month, the text box with the reference above displays "Error".
      I was fiddling with the Nz function trying to figure out how to
Click to expand...
Click to expand...
Click to expand...
 
Back
Top