Help, please!!

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

How can I make active/inactive (alternative) 2 textboxes in a MS Access form
using option buttons?

Thank you!
 
Chris said:
How can I make active/inactive (alternative) 2 textboxes in a MS Access form
using option buttons?
Click to expand...

Use code similar to the following in both the form's current event and the
option group's click or after update event. I am assuming Text1 will be
active, while Text2 is inactive. The option group (frame) will have 2
buttons with values 1 and 2.

Select Case OptionGroupControlName
Case 1
Text1.Enabled = True
Text2.Enabled = False
Case 2
Text1.Enabled = False
Text2.Enabled = True
End Select
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top