Help in MS Access

[Guest_imported]

This isn't exactly a VB question, but I'm working with VB to link with MS Access and I need to have on MS Access a text field on a table that has more than 255 characters. Is this possible because Access only allows 255! So how am I supposed to work with field that have more than this amount of characters?
Any help would be appreciated.

 

[edderic]

memofield ! Eric De Decker
vbg.be@vbgroup.nl

License And Copy Protection AxtiveX.

Download Demo version on my Site:

http://www.createsoftware2000.com

 

[drosenkranz]

Access's limitation of 255 characters can not be exceeded from VB. Remember- Access is still the engine under your app. You can use a memo field instead of character but searching it for values can get tricky but functions will work

InStr([fieldname],"bert&quot

would return the starting position and you could substr() it from there.

Bert in the memo field would return a 1
Robert in the memo field would return a 3

If you're asking about the text box itself, you can set the scroll bars property so you can have a small text box on your form with the ability to scroll through the text.

Good Luck
The 2nd mouse gets the cheese.