256 or memo

[seeker]

in access databases is there something between 256 and memo that can be used?
Memo does not work well and 256 size is too small for my users.

 

[Jeff Boyce]

It might help us offer specific suggestions if you described a bit more
specifically what you are trying to do. An example would be nice.

Simple answer, no. (but then, there may be a way to do what you need done,
other than what you've asked to do)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Duane Hookom]

Those are the options in Access.

 

[Klatuu]

no. There are no other options.

 

[seeker]

i have a textbox in a form. A user types and then eventually can not type
anymore text in the box. scroll bar is set on textbox. When user reaches
the 256 limit they can go no further.

 

[John W. Vinson]

in access databases is there something between 256 and memo that can be used?
Memo does not work well and 256 size is too small for my users.

Use Memo.

Perhaps you should explain what you mean by "does not work well". I use memo
fields all the time; when they're the right tool for the job, they're *the
right tool for the job*.

You have to put up with some limitations (you can't index them, or sort or
group by a memo without it truncating, etc.) but if you know the limitations
you can design around them.

 

[Jeff Boyce]

Again, that's "how", as in how you are trying to accomplish something.

What I was asking for is the underlying business need that will be
satisfied.

I'm pretty sure most users would not bother to type into a textbox for NO
reason. Why are they doing it? What do they (and you) hope to be able to
do AFTER they've typed something in?

Regards

Jeff Boyce
Microsoft Office/Access MVP