Greyout Fields

[John]

Hello,
I am trying to create database for the first time, and
one of the things I need it to do is to hide or geayout
some of the fields dependant on a tick being places in
anouther field.
Dose anybody know how this can be done ???

If so Please Help

Thanks
John

 

[Byron]

John,

We've all had that "first time."

I will assume that when you speak of a "tick" in another
field, that you are using either a checkbox or an option
button. In either case, you will need some code added to
the "AfterUpdate" event of your checkbox or option button
or, for that matter, what ever control you are using.

The "grey out" is refered to as disabled. So the control
is either enabled or disabled.

The code would be like:

to disable the control use:
Me.TheNameOfTheControlToBeDisabled.Enabled = False

to hide the control use:
Me.TheNameOfTheControlToBeDisabled.Enabled = True

HTH

Byron

 

[Bruce]

Am I missing something here, or should that part about
hiding the control be Visible = False?
To John, to add code to an event, double click the control
in Design View (or right click > Properties if the form is
already selected). Click the Event tab, then click next
to After Update (it is After Update in this case, but
there are many places to put an event, depending on your
needs). Click the three dots, click Code Builder, click
OK, then enter the suggested code between the lines that
read "Private Sub ..." and "End Sub". Save, then go back
to your form and give it a try.

 

[Byron]

Bruce,

Oops, of course you are correct. Just a slip up.

Sorry.

By the way, great explantion.

Byron

 

[John Green]

Thanks For your help
but how do I get the field to return to a disabled state
when the tick is removed say in the case of an error

 

[Byron]

John,

I don't think that I am clear about what you are wanting.
If you are wanting to attempt to prevent users from
accidentally unchecking the check box then you could
either present a message asking them if that really want
to uncheck the box. You might also consider disabling
the check box after it is checked to prevent it being
unchecked again. In this case you would first need to
prompt the user that they would not be able to uncheck
the box and if they agree, disable it. You would also
need to provide some method for being able to enable the
check box if it became absolutly necessary to uncheck it,
ike maybe creating a key combination that would enable
the checkbox. All of this would just make it more
difficult for users to mess it up.

Just a couple of ideas.

HTH

Byron

 

[Corrina]

Just use "If" in the code to specify whether to disable/hide or enable/show the control. In a check box, the value of a check is -1 and no check (white) is 0. (If the check box is grey, it has a null value.) The visual basic code for the After Update Event would look something like this

If [checkbox]=-1 The
(code to enable/show
ElseIf [checkbox]=0 The
(code to disable/hide
End I

Corrina Burnle
Burnley Data Solution
www.burnleydatasolutions.co

----- John Green wrote: ----

Thanks For your help
but how do I get the field to return to a disabled state
when the tick is removed say in the case of an erro