How can I set each field length?

[Guest]

How can I set each field length? I want my first field to start at 1 and go
to 3 (length 3). The second record needs to start at 4 and end at 18 with a
length of 15 and so on and so forth.
Thanks

 

[Rick B]

Huh? What are you asking? Are you building a table and what each field to
be a different length? How many fields will you have? What types of fields
are these?

I can't imagine a properly-designed database that would require this scheme.

 

[Pat Hartman\(MVP\)]

Sounds like you are trying to lay out a report. Use the sorting and
grouping properties of the report to create report levels so that you can
indent data appropriately.

 

[John Vinson]

How can I set each field length? I want my first field to start at 1 and go
to 3 (length 3). The second record needs to start at 4 and end at 18 with a
length of 15 and so on and so forth.
Thanks

What's the context? Are you trying to export data from an Access Table
to a fixed-width text file, or what?

Field lengths within an Access database aren't really very important.
A Table is *NOT* a text file, and doesn't have character positions;
text fields have sizes, but they are the *maximum* allowed size. A 255
byte text field containing "XYZ" actually occupies only three bytes
(plus a bit of overhead) on disk, since trailing blanks are not
stored.

As stated, your question really has no answer within Access!

John W. Vinson[MVP]