|
 |
access thread: Report Borders
Message #1 by Lonnie Johnson <prodevmg@y...> on Thu, 24 Jan 2002 08:25:30 -0800 (PST)
|
|
--0-833917740-1011889530=:45154
Content-Type: text/plain; charset=us-ascii
Hello EVERYONE. I need help. A couple of years ago I remember seeing some VBA code you could put in a report's module that would
draw a border around the parameter of the report's page. Does anyone know of any such script (or something equivalent)?
Much thanks in advance,,,,,
Lonnie Johnson ljprodev@y...
ProDev, Builders of MS Access Databases
Let ProDev build your next MS Access database application.
http://www.galaxymall.com/software/PRODEV
Get paid cash every time you receive email!
Sign up FREE at: http://www.MintMail.com/?m=975303
---------------------------------
Do You Yahoo!?
Yahoo! Auctions Great stuff seeking new owners! Bid now!
Message #2 by "ONeal, Byron" <ONeal@p...> on Thu, 24 Jan 2002 11:31:56 -0500
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1A4F4.A3C7CB80
Content-Type: text/plain
To Place Border on Report, insert the following in On Page Event Procedure
Me.DrawWidth = 15
Me.ScaleMode = 1
Me.ForeColor = 0 '255 makes it Red
Me.Line (0, 0)-(Me.ScaleWidth, Me.ScaleHeight), , B
-----Original Message-----
From: Lonnie Johnson [mailto:prodevmg@y...]
Sent: Thursday, January 24, 2002 11:26 AM
To: Access
Subject: [access] Report Borders
Hello EVERYONE. I need help. A couple of years ago I remember seeing some
VBA code you could put in a report's module that would draw a border around
the parameter of the report's page. Does anyone know of any such script (or
something equivalent)?
Much thanks in advance,,,,,
Lonnie Johnson ljprodev@y...
<http://us.f202.mail.yahoo.com/ym/ljprodev@y...>
ProDev, Builders of MS Access Databases
Let ProDev build your next MS Access database application.
http://www.galaxymall.com/software/PRODEV
<http://www.galaxymall.com/software/PRODEV>
Get paid cash every time you receive email!
Sign up FREE at: http://www.MintMail.com/?m=975303
<http://www.mintmail.com/?m=975303>
_____
Do You Yahoo!?
Yahoo! <http://rd.yahoo.com/mail_us/tag/?http://auctions.yahoo.com>
Auctions Great stuff seeking new owners! Bid now!
<http://rd.yahoo.com/mail_us/tag/?http://auctions.yahoo.com> --- Change
your mail options at http://p2p.wrox.com/manager.asp or to unsubscribe send
a blank email to $subst('Email.Unsub').
Message #3 by Lonnie Johnson <prodevmg@y...> on Thu, 24 Jan 2002 08:43:28 -0800 (PST)
|
|
--0-1237545855-1011890608=:81204
Content-Type: text/plain; charset=us-ascii
I have a solution. Actually two solutions. They are as follows:
1. Ed Tesiny from 'AccessDevelopers@y...' shared this.
Private Sub Report_Page()
Me.Line (0, 0)-(Me.ScaleWidth, Me.ScaleHeight), , B
End Sub
2. Byron ONeal from access@p... came up with this.
To Place Border on Report, insert the following in On Page Event Procedure Me.DrawWidth = 15
Me.ScaleMode = 1
Me.ForeColor = 0 ?255 makes it Red Me.Line (0, 0)-(Me.ScaleWidth, Me.ScaleHeight), , B Thanks to the both of you.
Lonnie Johnson ljprodev@y...
ProDev, Builders of MS Access Databases
Let ProDev build your next MS Access database application.
http://www.galaxymall.com/software/PRODEV
Get paid cash every time you receive email!
Sign up FREE at: http://www.MintMail.com/?m=975303
---------------------------------
Do You Yahoo!?
Yahoo! Auctions Great stuff seeking new owners! Bid now!
|
|
|
View Cart
