View Single Post
  #5  
Old February 8th, 2010, 07:06 PM posted to microsoft.public.access.forms
oldblindpew
external usenet poster
 
Posts: 128
Default Show code meaning rather than code value

What I'm wishing for is that the down arrow portion of the Combo Box would
disappear when the control is locked. It's just an aesthetic matter of not
wanting to show the user a non-functional control, and I think this would be
reasonable for the control to operate this way. Barring this, I would like
to use a Text Box, except I want to display the code's meaning from the
lookup table, rather than the code itself which is stored in the child table.
I suppose to do this I would have to join the lookup table to the child
table in my query, so my form would have access to that field?

I did not understand your suggestion about the Enabled and Locked
properties. A Combo Box will display the first column from the RowSource
that has a non-zero width, regardless of what you do with the Enabled and
Locked properties.

Thanks,
Pew

"John W. Vinson" wrote:

On Fri, 5 Feb 2010 15:45:01 -0800, oldblindpew
wrote:

I have a text box in a form that is displaying (as it should) the value of a
code that is stored in the bound field (hope I'm saying this right). I want
to display the code's meaning rather than its value.

I know a combo box would do it, and I'll use one if I have to, but I only
want to display the meaning, whereas a combo box is for picking a value.


It *can be used* for picking a value, but it doesn't force you to do so. In
fact if you set its Enabled property to No, Locked to Yes, it will display the
text value even though it's bound to the numeric value, but it will not let
the user affect either.
--

John W. Vinson [MVP]
.