Columns on a Form

[Guest]

Professionals: I have a form based on a 2-field table -- ID and name. I have
the form set to continuous. There are about 50 names in the table which will
not grow too rapidly. What I would like to do is to get the form to appear on
the screen in columns instead of using a vertical scroll bar and making the
user scroll down to see all the names. If I could get the form to appear in
columns I could present all the records to the user on one screen or after
the table grows by using the horizontal scroll bar. Thanks in advance.

 

[Guest]

How about having a bunch of text boxes on the form in columns. Then in the
code (maybe OnOpen event or OnCurrent event) you can loop through the data in
the table and put it into the various text boxes.

 

[John Vinson]

Professionals: I have a form based on a 2-field table -- ID and name. I have
the form set to continuous. There are about 50 names in the table which will
not grow too rapidly. What I would like to do is to get the form to appear on
the screen in columns instead of using a vertical scroll bar and making the
user scroll down to see all the names. If I could get the form to appear in
columns I could present all the records to the user on one screen or after
the table grows by using the horizontal scroll bar. Thanks in advance.

This can be done, but it's a bit awkward. You'll need to set up two,
three, or however many columns you want as tall narrow Subforms; each
subform would be based on a Query selecting a subset of the names.

If the purpose is to make it easy for the user to select a name from
the list, you might want to consider using a Combo Box instead of a
subform. If the combo's AutoComplete property is left True (it is by
default), the user can tab into the combo box and type the first
letter or two of the name; the combo will jump to that entry, with no
need for scrolling at all. This is good for up to several thousand
names.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps