Autonumbers and text fields

[Ringers]

I have two problems,

1. I have a text field set to allow 255 characters, but this is not enough space, i have also tried adding vertical bars, but this dosen't make a difference. How can i get more room, i found some information that said that memos would answer my problem, but i couldn't find them or get them to work.


2. I have a tbl_service with a PK of service_id. I have already assigned values to this field. the highest number in this field is 300. Now what i want to do is have this '300' appear in a text field, in a subform as a autonumber with +1 added to it. Each time a new record is needed.

If anybody can help that would be greatly appriecated.

 

[bjackson]

in design view of your table
select memo from the drop down list under datatype
for the field you want as a memo

i cant quite follow what you mean with question 2

 

[neileg]

For your autonumber, you can set the starting value of an autonumber. Look in the Access help files under autonumber.

Alternatively you could use an expression based on DMax for this field and add 1 for each record.