Grouping, Expand/Hide, and Memo fields

K

Kyle B.

I'm receiving an error message while trying to build a data access page:

In a Microsoft Access Database (.mdb), you can't group on a control bound to a field that has a Memo or OLE Object data type. In Microsoft Access project, you can't group on a control bound to a field that has an Image or Text data type.

I'm trying to use grouping to simplify the output of a search such that the user is not overwhelmed with details about a subject until clicking on the expand box. I’m don’t need the grouping function per se - I’m down in the level of individual records that do not need to be grouped.. In the high-level summary I'm providing to the user I would like to have a description field (Memo) and a few Text entries, except that when I try for that, I receive the above error.

Two questions emerge:
a) Can I perform the expand/hide action with a means other than using grouping?
b) Can I have fields in the grouping header that are not part of the grouping criteria?


Thanks for any help!
Kyle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top