Retyping on a form

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

Guest

when filling in the text boxes on a form, if i have already typed the word in
a previous form is there a way that i can get it to show up in the box im
typing in, for example, im typing the name of an organisation into a text box
on a form but i typed in the same organisation in another from, is there a
way that when i start to type in the name of the organisation it will appear
in the box befor i finish typing it. sorry if im abit confusing, by the way
im not that skilled to be using macro n stuff so if i have to plz let me no
where i have to put it in.
 
Krissy,
Instead of a bound text control for your Organization entry, replace it
with a combobox. The query behind the combobox, based on the the
Organization field from all previous entries, would allow the user to select
any previously entered Organization. With the combobox LimitToList
property set to No, you could add a new Org at any time.
Now... since comboboxes can have the AutoExpand set to Yes, as you type,
it will try to find the unique entry in the combo listing that matches what
you've typed. This is what you wanted...

Given these example previous Org entries
Boy Scouts
4H Club
Girl Scouts
Red Cross

In a new record, if you started to type "gi", the combo would know that
you mean "GirlScouts", and fill in the entry for you.

Study up on Comboboxes in Help... it's a very powerful tool, and used
properly... and in the right places on a form, a real productivity enhancer.
 
Thanks. Il think about it, but is there anyother way cause there is more than
likely 2 b at leaste 40 or so different organisations. Is there a way i can
do it where u cant c the arrow in the combo box. Would you be able to do it
in a list box then just make the size of the list box defult text box size.
 
Krissy,
I don't understand why you don't want to use a combobox?
It's the perfect way to allow a user to select an organization from a
fairly long list of values (40-60 would be reasonable). It's only as "tall"
as a regular text field, but expands, when needed, to allow the user to
manually select an Org, and also see many of the available choices at a
glance. And, given the AutoCorrect feature, a user can often make a combo
entry by just starting to type a known value.

You wrote...
Is there a way i can
do it where u cant c the arrow in the combo box.
Click to expand...
What problem could seeing the combo drop down arrow cause you?
Would you be able to do it
in a list box then just make the size of the list box defult text box
size.
Click to expand...
No. A "collapsed" listbox will force the user to scroll up and down to
see ANY of the 40 or so possible choices... a real pain and a real
productivity killer! It does not expand, when needed, to allow the user to
see multiple possible choices at a glance. List boxes are best used for
small quantities of preset values, the number of which rarely changes.
(maybe 5-10)

Given the question you asked, a combobox is the best solution.
 
Back
Top