Form and sub-form

[Mary Ann]

I have a table of companies and a table of people, with a one-to-many
relationship between them. I have created a form and sub-form (using the
wizard) so that I can see each company with the people in that company below.
However, I have a notes field (memo data type) in the people table, which I
want to see as a large control. What is the best way to achieve this?
I am using Access 2007.

 

[Al Campagna]

Mary Ann,
If I understand correctly...
I usually try to show just the first line or two of a large text control
on the form.
But, I code the Double-Click for that control to do a Zoom...

Private Sub YourMemoField_DblClick(Cancel As Integer)
DoCmd.RunCommand acCmdZoomBox
End Sub
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Mary Ann]

Thank you for your reply Al. I was looking for a simpler solution, preferably
without macros. I’ve discovered that you can create the sub-form and set the
notes control to be a large text box and then drag the sub-form onto the main
form. So, the sub-form can be a single form, doesn’t have to be a multi-line
datasheet, which is what I always got when I created the form and sub-form
using the form wizard.