display columns on Access form

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

Guest

I have a form which shows 900 property names. I have added a button next to
the property name that when clicked will display more detailed information
about the property. I would like to have the form display 2 or 3 columns
(across then down) rather than having to scroll through 900 rows to find the
property.
 
I have a form which shows 900 property names. I have added a button next to
the property name that when clicked will display more detailed information
about the property. I would like to have the form display 2 or 3 columns
(across then down) rather than having to scroll through 900 rows to find the
property.
Click to expand...

How do you identify the property? By name?

Might it help to have a Combo Box with an alphabetized list of names?
You could tab into the combo; start typing the name; and let
Autocomplete do its job and jump to the desired record. The Combo's
AfterUpdate event could then jump to the desired record. Use an
unbound Combo and the combo box wizard to set this up if you wish.

John W. Vinson[MVP]
 
A combo box is what we have now. One of the team members would like to make
a change to a list of names. Is there no way to have the list as columns on
the form?
 
A combo box is what we have now. One of the team members would like to make
a change to a list of names. Is there no way to have the list as columns on
the form?
Click to expand...

He wants to see a list 900 rows long on the form!!??

Sorry, but that's just silly. You'ld have to scroll either vertically
or horizontally anyway, or use 4 point type font and squint.

Yes, you can do it, using multiple Subforms (or Listboxes) arranged
side by side - but it would be a *horrid* user interface. Can you
perhaps instead train this user to take advantage of the tools that
Access provides? Are they perhaps manually scrolling down the list of
names (which is NOT necessary)?

John W. Vinson[MVP]
 
Back
Top