Table/Fields Question

B

Bob V

If I have to store 72 Alphabetical Letters , Do I then have to have 72
Different fields in my table, and do I make the field size 1?
Thanks for any Help..........Bob
 
A

Arvin Meyer [MVP]

It depends upon what you are doing. Normally, you would have 1 field and 72
rows of data.
 
B

Bob V

Hi Arvin,The problem is for printing purposes its 72 individual boxes that
have to make up words, so as each box on the paper form gets a letter in it,
...........Thanks Bob
 
B

Bob V

Hi Joseph, its actually 4 horse names to request a race name for a horse,
and the Authority have a paper form, that contains 4 rows of 18 boxes to
fill in. As 18 is the longest name you are allowed, so gaps are counted as a
letter .........Thanks Bob
 
J

John W. Vinson

Hi Joseph, its actually 4 horse names to request a race name for a horse,
and the Authority have a paper form, that contains 4 rows of 18 boxes to
fill in. As 18 is the longest name you are allowed, so gaps are counted as a
letter .........Thanks Bob
Click to expand...

This has nothing to do with either tables or fields. It's a Reports question.

Basically, you want to print the letters of "SEATTLE SLEW" in certain places
on a sheet of paper. This can be done using a Report - with either one textbox
and appropriate fonts and kerning, or if need be, by using 18x4 textboxes with
control sources like

=Mid([Horsename], 11, 1)

to print the 11th letter.

John W. Vinson [MVP]
 
Top