Columns in a form

[Guest]

I have a form with a list racing participant records. There are 2 fields in
each record, an identity number and "place". When the user clicks on an
identity number, the "Place" control in incremented by 1. More code then
resorts the list by place so that blank places are always on top and those
with places are in order at the bottom of the list.

The list can be long, too much for all competiors to show on the screen.
This is inconvenient for the user as she has to scroll up and down rather
than just point and click. Is there some way to have several columns on the
screen from the same source table/query?

i am using Access2000 with W2000.

Incidentally, why does the Newsgroup listing show some items followed by
"(office.access)" and some not? Its all Office Access, right?

 

[Guest]

Is there some way to have several columns on the

screen from the same source table/query?

You have a "list" of records, but you didn't explain whether this list is
displayed in a subform control or in a list box. If it's a subform control,
then the subform needs additional columns added from the record source, which
should be a query. If it's a list box, then open the form in Design View,
select the list box and open the Properties dialog window. Select the Format
tab and change the Column Count Property from 1 to as many columns as the
list box needs in the query. Change the Column Widths to indicate how wide
each column should be. For example, if the first column needs to be half an
inch wide, the second column needs to be a quarter inch wide, the third
column shouldn't show at all, and the fourth column should be one inch wide,
then use the following syntax in the Column Widths Property:

0.5";0.25";0";1"

And make sure that the list box's Bound Column Property is the ordinal
column designated as the primary key of the data source. Most people put the
primary key as the first column in a query (although the order of the columns
in a query doesn't matter), in which case the Bound Column Property for the
list box using this query would be 1.

Incidentally, why does the Newsgroup listing show some items followed by
"(office.access)" and some not? Its all Office Access, right?

Yes. They are all questions posted for MS Office's Access. However,
newsgroups have been created for each of the Office products and for products
listed in the Office newsgroups. For example, Microsoft created several
newsgroups in the Access newsgroup hierarchy listed as:

microsoft.public.access
microsoft.public.access.formscoding
microsoft.public.access.forms

I have no idea if Microsoft actually created these others, but similar
newsgroups in the Office newsgroup heirarchy were created:

microsoft.public.office.access.forms
microsoft.public.office.access.formscoding

If you see (office.access), then the user posted to the Office Access
newsgroup, not the Access newsgroup. Microsoft is trying to make the
microsoft.public.office.access.* newsgroups go away. (Obviously, in vain).
Please see this post:

http://groups.google.com/group/micr...5e959?q=Suzanna+Moran&rnum=1#a0757cc53505e959

But once created, newsgroups are hard to get rid of due to the automated
nature of the UseNet network. If anyone posts a message to a defunct
newsgroup, the message gets propogated to all news servers that haven't
removed this newsgroup yet.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
See http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

 

[Guest]

I can't figure out how to reply to '69 Camaro's reply-hope that this is the
way. Apparently I didn't phrase things right. Here is what I have
(simplified slightly.):

I have a table with only two fields. Both fields will be displayed on a
form. No subfrom or pull downs involved, just a single form sourced from
this table. The count of records is long, say max of 100 records. I want
the user to see all the records on the screen without scrolling down. This
means I would like columns, similar to what one does for a report.

The top row (and bottom) of the screen would look something like this, if
possible:
field1 field2 field1 field2 field1 field2

Each column of two records would be long enough to fill the vertical view of
the screen

Thanks in advance for any help.