473,386 Members | 1,647 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,386 software developers and data experts.

modified snaking columns

I have a report that uses snaking columns to generate four 2.5 inch
columns in landscape mode. It is used to print a double-sided document
whch is then cut down the middle and bound.

The problem is that I need to be able to make the spacing between
columns 2 and 3 larger than between 1 and 2 or 3 and 4, so that there
is sufficient room for the binding.

I hoped it might be possible to modify the locations of the columns
during the format event, but can't seem to find the necessary hooks.
The .Left property is read-only.

Does anyone here have any ideas?

Any suggestions will be appreciated.
Richard

Nov 13 '05 #1
3 1532
st******@cox.net wrote:
I have a report that uses snaking columns to generate four 2.5 inch
columns in landscape mode. It is used to print a double-sided document
whch is then cut down the middle and bound.

The problem is that I need to be able to make the spacing between
columns 2 and 3 larger than between 1 and 2 or 3 and 4, so that there
is sufficient room for the binding.

I hoped it might be possible to modify the locations of the columns
during the format event, but can't seem to find the necessary hooks.
The .Left property is read-only.

Does anyone here have any ideas?

Any suggestions will be appreciated.
Richard

Can't you go into the Print Setup and widen the Left margin and shorten
the right margin? You might not be able to do that...depending on the
print driver but it's worth a shot.
Nov 13 '05 #2
No, the margins work on the page, not the columns, and the wider
spacing needs to be between the 2nd and third column...
Richard
****
Salad wrote:
Can't you go into the Print Setup and widen the Left margin and shorten
the right margin? You might not be able to do that...depending on the
print driver but it's worth a shot.


Nov 13 '05 #3
st******@cox.net wrote:
No, the margins work on the page, not the columns, and the wider
spacing needs to be between the 2nd and third column...
Since there is no "generic" method of writing a report, you are stuck
with what you get. Maybe you could do this in Word or Excel...link to
the Access table and suck the report data in. There are some Word/Excel
newsgroups you could pose the question on.

The only other option I can think of is use Landscape instead of
Portrait and widen all of the columns.

Good luck.


Richard
****
Salad wrote:

Can't you go into the Print Setup and widen the Left margin and shorten
the right margin? You might not be able to do that...depending on the
print driver but it's worth a shot.


Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Bennett Haselton | last post by:
I'm working on an ASP.Net project where I want to test code on a local machine using a local database as a back-end, and then export it to the production machine where it uses the hosting...
4
by: Support | last post by:
Hi, I want to know if I have changed a few records in my database using update / insert / delete methods, how can i later know which rows have been changed or modified ? I know the...
2
by: DFS | last post by:
Main report contains one large graph in the detail band (no detail records). Subreport snakes just fine (5 columns) when opening by itself. When I add it to the main report (in the report...
6
by: (Pete Cresswell) | last post by:
I've got a situation where the user is expanding nodes in a TreeView and below a certain level, the child nodes become too numerous for them to deal with easily on a straight-up sequential list. ...
12
by: sandravandale | last post by:
It's important that I can read the contents of the dict without flagging it as modified, but I want it to set the flag the moment I add a new element or alter an existing one (the values in the...
102
by: hug | last post by:
www.webmaster, was suggested that this ng could be a better place.] I've updated my test server to handle if-modified-since. I've noticed that the (old copies I run of) IE and Netscape seem...
14
by: Yas | last post by:
Hello, I have 2 tables, Table1 and Table2. I have copied all data from Table1 to Table2. However Table1 is dynamic it has new rows added and some old rows modified everyday or every other...
3
by: andy | last post by:
dear all, how to know some fields were modified by user? list bellow my project: components: DataGridView,DataSet when user change the DataGridView colmons field value,we can use...
5
by: appmab | last post by:
In Access 2003 I have a multi-column report (3 columns). I would like to get 1 continuous vertical line from the top of the page to the bottom of the page, between columns 1 and 2 and between...
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: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
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
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.