Hi,

I'm looking for some advice on what the maximum field length is in Access. Which option will provide the maximum length. I am wanting the field to capture both numbers and text.

Any pointers in the right direction would be much appreciated.

Thanks in Advance.

Memo data type

And just as an FYI, if you want to know what your current version specifications are, go into the help file and type specifications and you should be able to get a list of all of the items and their specs. (same goes for Excel)

But I would be cautions about storing a jumble of data in a single field. You can be pretty sure that eventually you will want to split it out. Think about multiple fields/records rather than a single massive field.