Colors for Field/

[Marlita]

I need suggestions. I have created several tables. Some of my tables were
used to create forms. Some of my tables are just reference data for the
forms. For instance, I have a table called the City table, which lists
Cities and gives me a unique CityID. I use this CityID in my forms to
indicate what City is served.

I have several of these type of these reference tables. I have people
helping me enter data and i want to make it easy for them to read and know
where to put what. I would like to color coordinate the field from the
reference table with the field in the data entry form.

However, I know that you cannot color tables so, is there any other way that
I could accomplish this?

Also, how do I change the alignment of my cells in the tables? I would like
them to be centered.

Thank you

 

[John W. Vinson]

I need suggestions. I have created several tables. Some of my tables were
used to create forms. Some of my tables are just reference data for the
forms. For instance, I have a table called the City table, which lists
Cities and gives me a unique CityID. I use this CityID in my forms to
indicate what City is served.

I have several of these type of these reference tables. I have people
helping me enter data and i want to make it easy for them to read and know
where to put what. I would like to color coordinate the field from the
reference table with the field in the data entry form.

However, I know that you cannot color tables so, is there any other way that
I could accomplish this?

Also, how do I change the alignment of my cells in the tables? I would like
them to be centered.

Thank you

The users surely aren't opening the table in order to put in reference data,
are they!? Create a very simple (forms wizard is fine) maintenance Form to
enter data into your reference tables. The user need not know any tablenames,
and certainly should not need to open any tables at all.

 

[Marlita]

Hi John. Thank you for responding. I have created the form and they are
entering data into the form. They don't touch the tables. I printed the
tables out so they could look up the cityID number for Los Angeles and enter
that number into the form, if that makes sense.

 

[Gina Whipp]

Marlita,

Why not make a combo box (CityID, CityName), hide the first column so they
could just type the name but in your table would be the CityID? I guess I
do't understand the color coding thing because I have about 100,000 cities
in my talbe and that's alot of color coding!

To center data in a field, in design mode, highlight and celect center from
the toolbar.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm

 

[John W. Vinson]

I printed the
tables out so they could look up the cityID number for Los Angeles and enter
that number into the form, if that makes sense.

Ummm... No. It doesn't. Don't make people do work that a computer can do much
better! The user should never even KNOW the cityID, much less have to look it
up or type it!

Use the tools Access provides. You can put a "Combo Box" control on the form,
bound to the CityID field in the table. This combo would be based on the City
table, with the CityID as its bound column, and the city and state name as the
visible columns (you do want to distinguish Las Vegas, NM from Las Vegas, NV,
not to mention the forty or more Springfields). The user can simply select Los
Angeles from the combo box, *by name*, and it will store the ID.