simple quest, defining a text field > 255 character? 1

[lanelouna]

Hello,
for many of you my quest may be very simple
i would appreciate it if you could help me
i have this field in a table that i want to populate with a very very long string, a concatenation of values and strings
something more than 255 characters

but what i actually do in the code is the following
Set chp6 = dft.CreateField("Mission", dbText, 255)
dft.Fields.Append chp6
dft.Fields.Refresh

how should I define my field so as to cater for the whole string?
thank you in advance
an example of my string is this:

N=80862, 80863, RT=2, N=80864, RT=3, N=80865, RT=4, N=80866, RT=5, N=80899, RT=6, N=80867, RT=7, N=80868, RT=10, N=80869, RT=11, N=80870, RT=12, N=80871, RT=14

Lina

 

[hymn]

Change the field type to Memo

Hope this helps
Hymn

 

[lanelouna]

Thanks alot Hymn
it worked
I am happy!
have a good day
Lina