A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Convert text to Combo



 
 
Thread Tools Display Modes
  #1  
Old May 17th, 2010, 06:36 PM posted to microsoft.public.access.queries
Mickey[_4_]
external usenet poster
 
Posts: 5
Default Convert text to Combo

Hi,
I have some 20,000 entires populating a text filed that ideally should
be a combo box. I'm looking for the best way forwards with this and
wonder if there is any alternatives for what I need to do. The data in
the text field needs to be restricted to a small number of options, I'm
thinking that I need a combo box for this but then the original data
will be in a different field.

Is it possible to create a new combo box and then populate it with the
data from the text field retrospectively or is there some other way
forward for this problem?

I would be very grateful for any advice as i am new to Access and may
be barking up the wrong tree so to speak!

Regards,
Mickey

  #2  
Old May 18th, 2010, 03:32 AM posted to microsoft.public.access.queries
Allen Browne
external usenet poster
 
Posts: 11,706
Default Convert text to Combo

If the combo's bound column is NOT hidden, you can restrict the combo's
RowSource so it only provides the options the user is likely to need, set
its Limit To List property to No, and it will show/allow any valid value
(perhaps limited by a relationship to a lookup table where you used
enforced Referential Integrity.)

If the combo's bound column is not the display value, you can place your
text box on top of the combo (so it shows the values that are not in its
list.) Use the text box's Got Focus event to SetFocus to the combo.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Mickey" wrote in message news:2010051718361027698-oik@mecom...
Hi,
I have some 20,000 entires populating a text filed that ideally should be
a combo box. I'm looking for the best way forwards with this and wonder
if there is any alternatives for what I need to do. The data in the text
field needs to be restricted to a small number of options, I'm thinking
that I need a combo box for this but then the original data will be in a
different field.

Is it possible to create a new combo box and then populate it with the
data from the text field retrospectively or is there some other way
forward for this problem?

I would be very grateful for any advice as i am new to Access and may be
barking up the wrong tree so to speak!

Regards,
Mickey

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.