use 2 rows (or larger space, somehow) for column name

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

Guest

I am trying to set up an access table and need to name columns (fields) with
longer, descriptive names but where very little info will be required. For
Example:
column name: Initials of staff/volunteer
Info needed (2 letters): DP
 
dougp said:
I am trying to set up an access table and need to name columns (fields) with
longer, descriptive names but where very little info will be required. For
Example:
column name: Initials of staff/volunteer
Info needed (2 letters): DP
Click to expand...

If you are looking at the table directly, then no, you can't make the column
names span more than one row.

However, it is poor practice anyway to work directly in your table. You
should create a continuous form with which to maintain your table. Then,
you can use labels as the column headers, and you can format them however
you like.

Incidentally, don't use spaces in column names, it will cause endless
irritation in future. Personally I like to use underscores e.g.

initials_of_staff_or_volunteer
 
The name of the field can be as long as you like but set the size of the
field to 2 (in your example). You do this when you modify the table. This
will only work if you set the 'Field Type' to: TEXT
It would be a good idea to use names without spaces (or other charachters)
as it is easier when you get around to code. Eg. InitialsOfStaffVolunteer
 
I am trying to set up an access table and need to name columns (fields) with
longer, descriptive names but where very little info will be required. For
Example:
column name: Initials of staff/volunteer
Info needed (2 letters): DP
Click to expand...

No. You don't need to do this.

Don't confuse data STORAGE - done in tables - with data DISPLAY - done
in Forms for onscreen use or in Reports for printing. They are
*different activities* with *different requirements*.

Fieldnames should be short, simple, and should not contain special
characters. [Init] or [Initials] would make a good fieldname for this
example.

You can set the Caption property of the field to "Initials of
staff/volunteer"; when you create a Form or Report using that field,
it's the Caption which will be displayed. Or, you can put whatever
text you would like to see on the label attached to the Form or Report
textbox.

If you're printing table datasheets for reporting purposes... well,
don't. That's not their function.

John W. Vinson[MVP]
 
Back
Top