Blank out a box in a form if this one is filled in

Joined
Aug 4, 2009
Messages
1
Reaction score
0
Hi guys

First time poster here!

I used to be quite good at access, but just having another go after many years of not using it. Hopefully this isn't a difficult one..

In a form (Contact Details)

I have a combo box with a value list (Access type) - the list being Type A and Type B.

Then I have the following fields
Type A IP Address
Type A UserID
Type A Password
Type B UserID
Type B Password

My question is this...

When Type A is chosen in Access Type,
I want the user to enter details in
Type A IP Address
Type A UserID
Type A Password

But not in the Type B UserID, or Type B Password fields

When Type B is selected in Access Type
I want the user to enter details in
Type B UserID
Type B Password

Is there a way of hiding or greying out the fields I don't want them to type in?

Your help with this is really appreciated.

Thanks
 

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