Text Box, can I add a drop down button?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there all,

In Excel, I can do this:

TextBox1.ShowDropButtonWhen = fmShowDropButtonWhenAlways
TextBox1.DropButtonStyle = fmDropButtonStyleEllipsis

Which will add a little button to the end of the text box with three little
dots in it. Very nice indeed.

My question is, how can I do that in access? I tried applying the same
properties to a text box in access but it (of course) didn't work.

Cheers,
Pete
 
Foss said:
Hi there all,

In Excel, I can do this:

TextBox1.ShowDropButtonWhen = fmShowDropButtonWhenAlways
TextBox1.DropButtonStyle = fmDropButtonStyleEllipsis

Which will add a little button to the end of the text box with three
little dots in it. Very nice indeed.

My question is, how can I do that in access? I tried applying the same
properties to a text box in access but it (of course) didn't work.

Cheers,
Pete
Click to expand...

Change to a ComboBox.
 
Hi there Rick,

I thought that might be the only way, ah well! I'll just have to add a small
button to the right of the text box!

I don't think the effort will kill me! ;-)

Cheers,
Pete
 
Foss said:
Hi there Rick,

I thought that might be the only way, ah well! I'll just have to add
a small button to the right of the text box!

I don't think the effort will kill me! ;-)
Click to expand...

Is there any reason why you don't want to just use a ComboBox?
 
Well with the text box with a button, you get an on button press event type
thing. This means that I can use it for things other than just lists.

When I do the same with a combo box, it looks rather messy as when you press
the button it always brings up the empty list before doing what it's told.

I know it's not a big thing but I like things to look as smooth as possible
as it makes the customers a little happier..
 
Foss said:
Well with the text box with a button, you get an on button press
event type thing. This means that I can use it for things other than
just lists.

When I do the same with a combo box, it looks rather messy as when
you press the button it always brings up the empty list before doing
what it's told.
Click to expand...

Try the GotFocus event. I often use a ComboBox that is sized such that all
you see is the drop-arrow.
 
Back
Top