Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / May 2008

Tip: Looking for answers? Try searching our database.

subform and memo fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JohnE - 22 May 2008 21:48 GMT
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
JohnE - 23 May 2008 04:16 GMT
Disregard this.  I got it figured out.
Thanks.
... John

> 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
[quoted text clipped - 10 lines]
>
> ... John
Jan Baird - 27 May 2008 20:51 GMT
Jan Baird is out of the country until September 20.   Every effort will be
made to respond to messages, but please be patient.
Graham Mandeno - 23 May 2008 04:37 GMT
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
Signature

Good Luck  :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

>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
[quoted text clipped - 13 lines]
>
> ... John
Jan Baird - 27 May 2008 20:51 GMT
Jan Baird is out of the country until September 20.   Every effort will be
made to respond to messages, but please be patient.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.