".enabled = False" format for listboxes etc.

[Mark Kubicki]

if I make a textbox disabled, or a label, etc... it "looks" disabled (it's
"grey'd out")

however,
if I make a list box (or combo, or subform...) it still looks the same
this is causing confusion among the end users (when can they... and when
can't they...)

doers anyone have any trick or tips on how to handle this issue?

(ps: it probably does not make sense to use the visible property...)

thanks in advance,
mark

 

[Dirk Goldgar]

In

if I make a textbox disabled, or a label, etc... it "looks" disabled
(it's "grey'd out")

however,
if I make a list box (or combo, or subform...) it still looks the same
this is causing confusion among the end users (when can they... and
when can't they...)

doers anyone have any trick or tips on how to handle this issue?

(ps: it probably does not make sense to use the visible property...)

List boxes are a pain in this regard, because Access won't let you
display another control on top of them.

If the list box has an attached label, that label will be grayed out if
the list box is disabled. That's not terribly noticeable, however.

You could put a box control around the list box to indicate that its
disabled, and hide that control when the list box is enabled.

You could hide the list box and display something else in its place, but
then your users wouldn't be able to see the selected value(s) in the
list box. I guess you could hide the list box and display instead a
disabled text box showing just the selected values. You'd give this
text box a controlsource expression that returns the selected values in
a string with line breaks embedded between the values.