Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-24-2008, 04:34 PM   #1
AN60
Newly Registered User
 
Join Date: Oct 2003
Posts: 283
Thanks: 1
Thanked 5 Times in 5 Posts
AN60
Line Thickness in Report

I am using something similar to the following in report & a module to draw a elipse around a field. I want to increase the thickness of the line but have had problems. I've fiddled with drawwidth without success. Any suggestions?


Private Sub Detail_Format(ByRef intCancel As Integer, _
ByRef intFormatCount As Integer)


If Me.txtXYX > 500 Then
HighlightControl Me.txtXYZ, vbRed, 0.35
End If


Module


Option Explicit
Option Compare Text


Public Sub HighlightControl(ByRef ctlControl As Control, _
ByVal lngColour As Long, _
ByVal sngAspect As Single)

With ctlControl
' Remove the current border.
.BorderStyle = 0

' Draw the ellipse.
.Parent.Circle (.Left + .Width / 2, _
.Top + .Height / 2), _
.Width / 2 + 50, _
lngColour, , , _
sngAspect
End With

End Sub

AN60 is offline   Reply With Quote
Old 02-24-2008, 09:31 PM   #2
ChrisO
Newly Registered User
 
ChrisO's Avatar
 
Join Date: Apr 2003
Location: Brisbane, Australia
Posts: 3,202
Thanks: 7
Thanked 275 Times in 195 Posts
ChrisO is just really nice ChrisO is just really nice ChrisO is just really nice ChrisO is just really nice
ctlControl.Parent.DrawWidth = 100
__________________
Access 2003, Win7, GMT +10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
ChrisO is offline   Reply With Quote
Old 02-25-2008, 01:22 AM   #3
AN60
Newly Registered User
 
Join Date: Oct 2003
Posts: 283
Thanks: 1
Thanked 5 Times in 5 Posts
AN60
Thanks ChrisO that's just what I wanted. About 10-20 is ideal for me.

AN60 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting a Line Break on a Report shadow9449 General 10 09-08-2006 01:26 PM
Insert line every 5 recods in report yaac Reports 0 03-13-2006 09:13 AM
Not sure if problem is report or form huertalm Forms 3 03-06-2003 01:06 PM
[SOLVED] Printing blank line every 5th line in a subreport. RMcIntire Reports 1 05-22-2002 01:22 PM
Help! Subject line on report sent via e-mail FC Reports 2 06-06-2001 09:00 AM




All times are GMT -8. The time now is 08:08 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World