Rich Text control to make a dynamic continuous form

[Dave C]

I have a continuous form that displays three different types of records.
It's a travel application, so the records for a hotel room, timeshare, and
cruise display different fields and information. However, as these elements
can all be part of the same trip, I want them to display in the same list.

Because native Access 2007 can't support a true dynamic record, I developed
a VBA function that creates HTML marked-up text that creates what should be
displayed for each record.

This works fine if I use the routine to store the HTML in a memo field and a
bound control on the form. However, what I'd really prefer to do is create
it as an expression in a query that's used as the data source for the form.
(I don't want to have to track all the places that data in the table can be
changed and update the HTML field.)

When I try to do it this way, though, it won't let me set the control's
property to Rich Text because the expression in the query...

HTML_Line1:MakeHTML(blah blah blah)

....doesn't result in a Memo type field.

Is there a way to:

Set the text format property to Rich Text for a control bound to a text
field instead of a memo field,

or format a query to specifically create a memo field as the result of an
expression,

or solve the problem some other way?

Thanks!

 

[Dave C]

I should point out that this form lists the vacation details as display-only.
The records have an "Edit" button that opens an edit window specific to the
type of segment.