256 or memo

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.

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

"seeker" wrote in message
...
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.

Those are the options in Access.

--
Duane Hookom
Microsoft Access MVP


"seeker" wrote:

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.

no. There are no other options.
--
Dave Hargis, Microsoft Access MVP


"seeker" wrote:

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.

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.

"Jeff Boyce" wrote:

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

"seeker" wrote in message
...
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.

On Fri, 12 Jun 2009 14:17:02 -0700, seeker
wrote:

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.
--

John W. Vinson [MVP]

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

"seeker" wrote in message
...
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.

"Jeff Boyce" wrote:

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

"seeker" wrote in message
...
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.