473,387 Members | 1,693 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Report Help

14
I have a report that is based off a table that has many different fields on it and I have a form that the user can choose which fields they want to display. Right now if you choose more then the width of the report, it just puts the extras behind the other ones and not on to a second sheet. Is there away to have it do more then one sheet if necessary?

Thanks
Jan 4 '16 #1
2 969
zmbd
5,501 Expert Mod 4TB
We need a little more information about how you are adding your extra fields.

In the meantime, you might find the following link useful - I think this is what you are attempting to accomplish:
How to programmatically create a new column in an Access report

You may find this article of some interest too:
Create Dynamic Report using VBA

Oh, I should mention, in the Microsoft link, the DAO library reference is set by default in newer versions of Access - if you are using Acc2010 or newer for sure... not sure about ACC2007 - we skipped that version in the lab!
Jan 4 '16 #2
NeoPa
32,556 Expert Mod 16PB
I would start with the largest number of TextBox controls that you think you might need, but set them all up as hidden (.Visible = False).

Determine from the stationery the printer is set to use, or just assume the default, which is A4 in The UK, Letter in The States and I know not elsewhere, how much horizontal space is available. When you know that then add the fields into the controls as necessary and assign widths to each however you do that, then align them horizontally across the page until it no longer fits in the space available. At that point increase the height of the (.Detail) section and add another row of controls. Keep doing this until you have included all the fields selected.

NB. Each control you want to include must be set as visible (.Visible = True).
Jan 5 '16 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Mike | last post by:
Hello All, I'm trying to deploy my windows-based application using crystal report. i package the setup by including the crystal report file, the exe file, and two merge modules for the crystal...
0
by: Tiago Miguel Silva | last post by:
I there. I´m almost desperate with a report that i´m doing! I am creating a report using the push method, being the data returned by a typed dataset. The report shows activities by week and...
1
by: Neil MacDonald | last post by:
Hi. Thanks in advance for your help. I have a database in which one report will not show the text from a memo field. If I run the underlying query, the field shows up in the table, with all...
1
by: steven | last post by:
I am creating some financial reports in Access 2000, and I am having problem that I can't resolve. The report sorts information first by vendor, then by budget line number. It generates the...
2
by: report help | last post by:
I have a report that is supposed to be two pages. The first page should contain the header, some data from a query, and the footer. The second page should contain the header, two subreports, and...
6
by: Takeadoe | last post by:
Dear NG - I'm very new to Access and reports are completely foreign to me. I was hoping that I could get some general guidance on how to proceed with the following: I've got a form (8.5x11")...
0
by: DhavalPatel1983 | last post by:
Hi All, I need ur help in Visual Baisc for Data Report. Description ========= I have one Project Which include One Data Envirnment,Data Report,Form Which contain Listview,Text box, and...
3
by: DeanL | last post by:
Hi guys, I'm in need of a little help with a report I'm setting up on Access 2000. The report shows data depending on entries on a form that has 7 fields (Min and Max Cost, Fiscal Year, Min and...
3
by: ranesmitas | last post by:
hello, i using vb 6 and i did report seagate crystal report . i want to know how it use in vb . i did some code but it not display anything code is Public strReportPath As String Public...
0
by: adsaca | last post by:
there basic sections in Crystal report namely Report Header Page Header Group Header Details
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.