Multi-Column continuous form

[Dave]

Is it possible to create a multi-column continuous form?

IOW can I create a two column continuous form where I display two records on
the same line, kind of like newspaper columns where the text goes all the
way to the bottom of one column and then starts again at the top of the
adjacent column on the same page?

I realize this is an unusual request but can it be done and if so, how?

 

[Peter Hibbs]

Dave,

I don't believe there is any standard control that will do that but a
Flex Grid Control will probably do what you want, but you will need to
write a bit of VBA code. Have a look at my Flex Grid Demo program for
some examples. Item 6 on the menu has a similar example of what you
want to do.

Go to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

HTH

Peter Hibbs.

 

[Albert D. Kallal]

If the records can be related by SQL joins, then you could simply join the
two tables together and display the two columns that way. It's not quite
clear how the two records are related to each other, but mice by defense
tells me the fact that you want display to record side by side means there's
likely some type of relationship between them.

So, join the two tables together with a SQL query, and simply use that as
the data source for the continuous form.

 

[John W. Vinson]

Is it possible to create a multi-column continuous form?

IOW can I create a two column continuous form where I display two records on
the same line, kind of like newspaper columns where the text goes all the
way to the bottom of one column and then starts again at the top of the
adjacent column on the same page?

I realize this is an unusual request but can it be done and if so, how?

Would it suffice to have two continuous forms side by side? Depending on the
nature of the recordsources, you may be able to base the left hand subform on
a query selecting a fixed number of records, and the right hand on a query
excluding those. Having records scroll from left to right when you add or
delete records might get tricky!

 

[Mark Han[MSFT]]

Hi David,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that you would like to create a
multi-column continuous form. If I have misunderstood, please let me know.

After reviewing the public response to you, I found that John has given you
a answer. if we could create two continuous forms is based on the
recordsources.

If there is anything unclear, please let me know. Have a nice day!

Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx

============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

 

[Mark Han[MSFT]]

Hi David,

I'm Mark Han. i'm writing to follow up the post.

I would like to know the status of the issue.

I look forward to hearing from you. Thanks

Best regards,
Mark Han
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================