subform and memo fields

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

I have a form that is a popup form. I would like to have the form as a
continuous form for listing out the information, which works fine. But 2 of
the fields are memo fields and cannot be placed on the subform. I thought
about making the popup with a subform for the task list and place the memo
fields on the main form, but that didn't work (or at least I couldn't get it
to work). The popup form is a listing of tasks.

I am at a loss on what/which way is the better way and getting it to work.
So I ask the group if anyone has any suggestions or thoughts or may have done
something similar to get me back on track.

Thanks.

.... John
 
Hi John

There should be nothing stopping you from putting a memo field on a
continuous form. Is the problem one of space?

There are two possible options: one is to put the textboxes for the memo
fields in the footer of the subform, so that they are only displayed for one
record at a time.

The other is to make them just one line deep in the detail section, but use
the built-in zoom box to edit them. You could use the Click or DblClick
event for this:
DoCmd.RunCommand acCmdZoomBox
 
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
Back
Top