Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / August 2005

Tip: Looking for answers? Try searching our database.

Can I add text to combo box as message?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Aaron G - 30 Aug 2005 16:06 GMT
Using Access 2003 - I have a combo box that works fine.  However, I would
like to add some text in it as a message for users to click there (ala the
"Type a contact to find" combo box in Outlook 2003).  

Is this possible in Access?

TIA

Aaron G
Philadelphia, PA
Klatuu - 30 Aug 2005 16:12 GMT
Use the ControlTip Text property of your combo box.  The text in the property
will show in a little yellow box when you position the mouse over it.

> Using Access 2003 - I have a combo box that works fine.  However, I would
> like to add some text in it as a message for users to click there (ala the
[quoted text clipped - 6 lines]
> Aaron G
>  Philadelphia, PA
Aaron G - 30 Aug 2005 16:21 GMT
Klatuu,

Thanks for the response.  I'm looking for something that will draw the users
eyes there without having to mouse over.  I'm going for a really clean look
and don't have a "Seach" label attached either.  

Can I put some kind of text in that will disappear when you click on it and
won't effect my after update event?

Thanks again.

Aaron G
Philadelphia, PA

> Use the ControlTip Text property of your combo box.  The text in the property
> will show in a little yellow box when you position the mouse over it.
[quoted text clipped - 9 lines]
> > Aaron G
> >  Philadelphia, PA
Klatuu - 30 Aug 2005 16:34 GMT
I'm not sure what you are asking for.  What do you mean by "Search" label?
If you mean you want text in the combo where the list of options is, it can
be done with a value list, but you would have to deal with it
programmatically.
It may be easier to create a label and position it just above the combo,
then make it invisible when the user selects from the combo.  You would also
have to use the Current event of the form to make in visible for the next
record.

> Klatuu,
>
[quoted text clipped - 23 lines]
> > > Aaron G
> > >  Philadelphia, PA
George Nicholson - 30 Aug 2005 17:22 GMT
One approach might be to create a label or unbound textbox with your message
that sits *exactly* on top of your bound combobox.  When the unbound textbox
is clicked, give the bound combobox the focus (sending the unbound textbox
"to back").

Not sure from your post if you would ever want to give focus to the unbound
control again much less when you would want that to happen. It sounds like
you only want this for an "initial use" view when an empty form first opens.

HTH,
Signature

George Nicholson

Remove 'Junk' from return address.

> Klatuu,
>
[quoted text clipped - 29 lines]
>> > Aaron G
>> >  Philadelphia, PA
Aaron G - 30 Aug 2005 18:31 GMT
George,

That's simple and will do nicely!  Thanks.

Aaron G
Philadelphia, PA

> One approach might be to create a label or unbound textbox with your message
> that sits *exactly* on top of your bound combobox.  When the unbound textbox
[quoted text clipped - 39 lines]
> >> > Aaron G
> >> >  Philadelphia, PA
George Nicholson - 30 Aug 2005 19:25 GMT
Well, I'm not sure about simple, but ok... :-)

Signature

George Nicholson

Remove 'Junk' from return address.

> George,
>
[quoted text clipped - 53 lines]
>> >> > Aaron G
>> >> >  Philadelphia, PA
Dirk Goldgar - 30 Aug 2005 16:48 GMT
> Using Access 2003 - I have a combo box that works fine.  However, I
> would like to add some text in it as a message for users to click
> there (ala the "Type a contact to find" combo box in Outlook 2003).
>
> Is this possible in Access?

It seems to me this is very similar to the often-asked question of "how
to add '(all)' to a combo box".  So the approach described here:

   http://www.mvps.org/access/forms/frm0043.htm
   Forms: Adding "All" to a listbox or combobox

could be adapted to your needs.  If you use Null as the bound-column
value corresponding to your message text, then your AfterUpdate code can
just verify that the combo box value isn't Null before charging off to
find the record the user selected.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Aaron G - 30 Aug 2005 18:33 GMT
Dirk,

Thanks for the post.  I think I'm going to go with George's solution just
for simplicity's sake, but it looks as if this would solve the problem as
well.  

Thanks.

Aaron G
Philadelphia, PA

> > Using Access 2003 - I have a combo box that works fine.  However, I
> > would like to add some text in it as a message for users to click
[quoted text clipped - 12 lines]
> just verify that the combo box value isn't Null before charging off to
> find the record the user selected.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.