Text size only 255?

[Bob]

Can this be increased to 350? In a Field table!
Thanks.............Bob







..........Jenny Vance

 

[Wayne-I-M]

Hi Bob

Not in a Text Box but you could format the field as a Memo


--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.

 

[fredg]

Can this be increased to 350? In a Field table!
Thanks.............Bob

.........Jenny Vance

Not if the field datatype is Text.
Change it to Memo datatype and you can enter 65,000+ characters.

 

[Bob]

Thanks Fred but if I only need 350, by selecting Memo, wont this be adding a
lot of memory size to the db...Thanks Bob

 

[Albert D. Kallal]

Thanks Fred but if I only need 350, by selecting Memo, wont this be adding
a lot of memory size to the db...Thanks Bob

Actually, a field defined as length 5, or 255 uses the same space (the blank
data is NOT stored). so, ms-cess has a modern data engine that stores data
as variable length.

A memo field also have this feature....

The only draw back of a memo field is that you can't use indexing on the
field for high speed searching....

 

[Bob]

Thanks Albert, but why does my Text Box no get a scroll bar to the right
when the text box is filled .......Thanks bob

 

[Albert D. Kallal]

Thanks Albert, but why does my Text Box no get a scroll bar to the right
when the text box is filled .......Thanks bob

There is a setting in the properties sheet for the text box.

You can set the "scroll bars" to vertical, or none.

You find this setting in the property sheet "format" tab

 

[aaron.kempf]

well shit bud; I can index VARCHAR right?

Access Data Projects sure aren't limited to 255 characters

ROFL