Memo field truncated (and) auto number problem

[MaxineGray]

Hello! I am building my first data base. I am trying to copy & paste about
1,000 characters of text from Word (plain text, no formatting) for a memo
field, but it truncates (error message) after about 2 sentences. It says it
is too long to edit. I am certain this is a memo and not text field, and I
made the text box big enough (with scroll bars) to accommodate the text.

Also, I'm using autonumber but the very first record started at #23--what's
up with that?

By the way, I installed version 2003 but it opens as 2000.

Please help!!

 

[MaxineGray]

PLEASE CANCEL THE FIRST PART OF MY POST!
Sorry--it wasn't memo after all; I had two fields with similar names and I
mixed them up. Sorry. Still would like a reply to the autonumber Q, however.
Thanks.

 

[John Vinson]

Also, I'm using autonumber but the very first record started at #23--what's
up with that?

An Autonumber has one purpose and one purpose only: to create an
almost-guaranteed (there are rare bugs) unique identifier.

Once an autonumber is used, or even when you START a new record and
then cancel it, that number is gone forever, even if you delete the
records in the table. At some point you entered 22 (test?) records in
the table, incrementing the autonumber.

For this reason - and others - you should NOT treat autonumbers as a
"record number" or "linenumber"; most developers conceal autonumbers
from user view altogether.

John W. Vinson[MVP]