I have a field that is in text format that is used as a discussion box. This limits the user to 250 characters because of Access limitations. I have tried the memo format but that will not allow me to query off of that field. How can I have this discussion field with unlimited text capability and also be able to query off of it? Any help is greatly appreciated. Thanks!
Making text field larger
- Thread starter jamphan
- Start date
- Local time
- Today, 02:45
- Joined
- Feb 28, 2001
- Messages
- 30,499
This is called "having your cake and eating it too." You cannot do this. It is a limitation of MEMO fields that you cannot do full-blown queries. However, I believe you can still do partial-search queries using functions of the memo fields. For instance, you can do a query that includes an InStr function and let the InStr find the thing you seek.
A MEMO field cannot have an index; this forever curtails general queries involving JOIN or other similar SQL actions.
Without knowing more of what you want, it is hard to answer your question CONstructively. The only option I have is DEstructive; i.e. you can't do what you asked to do.
Tell us what you REALLY wanted to do and one or more of us might be able to suggest work-arounds.
A MEMO field cannot have an index; this forever curtails general queries involving JOIN or other similar SQL actions.
Without knowing more of what you want, it is hard to answer your question CONstructively. The only option I have is DEstructive; i.e. you can't do what you asked to do.
Tell us what you REALLY wanted to do and one or more of us might be able to suggest work-arounds.
I need for the entire filed to show. My database form contains information pertaining to conversations a user has with various regions. The discussion box would hold the contents of what was discussed and any additional information that was relevant. This discussion, entire discussion, would need to be available in a history sub form I have on the form so the user can select a region and it would display everything that has ever taken place that was entered in the database, such as discussions. A work around would be fine but this one thing is going to make the difference between a very useful tool or a scrapped hunk of junk. Please help!!!! Many man hours have been put in to this thing. Thanks!!!
- Local time
- Today, 02:45
- Joined
- Feb 28, 2001
- Messages
- 30,499
That much is easy - other than that when it gets big enough, you will have to scroll-bar your way through it.
It has been a while, but I did something like this in Ac97, having to do with a repair narrative for a problem-tracking system. (It wasn't optimal, but then again, it was a stop-gap measure until "the real thing" could be built.)
You say you cannot get this to work? Almost any Access Form with an appropriately formatted text box should be able to do this. I guess I don't understand where you are having the problem. Are you trying to do this via ASP or a "real" Access form? Which version of Access? Do you see an error message, truncation, or something else?
We need symptoms. No symptoms, no diagnosis.
I am in Access 97. The symptoms are first the limitations on the amount of text in a text formatted field which is 250 characters. The memo format is the only way I know of that will allow all the space a user could possibly need. The problem in this is when I go to my query for my subform which has multiple fields one of which contains a where parameter that says when the Region is selected on the Form, the subform will populate with its history which is my query but the query will not run when the Discussion field is in Memo format. I get a "Can't Group on Memo or OLE object" error message. That is the issue that is holding me down.
