How to draw a Dot Line in report

[Guest]

I am trying to draw a line by the following code :

Private Sub Report_Page()
Me.Line (0, 2880)-Step(8640, 0)
End Sub

The code is working fine But My requirement is to draw a line in Dot style
(I mean manually if we draw a line we can set in properties Dailog - Border
Style - Dot).

Please advise me what additional code I should add to get my above line
drawn a Dot Line.

Regards.

Irshad

 

[fredg]

I am trying to draw a line by the following code :

Private Sub Report_Page()
Me.Line (0, 2880)-Step(8640, 0)
End Sub

The code is working fine But My requirement is to draw a line in Dot style
(I mean manually if we draw a line we can set in properties Dailog - Border
Style - Dot).

Please advise me what additional code I should add to get my above line
drawn a Dot Line.

Regards.

Irshad

Look up the DrawStyle property in VBA help.

Me.DrawStyle = 2
Me.DrawWidth = 1
.......
Me.Line(etc...)

 

[Guest]

Thank your for your help.

I tried its working about 90%. Its ok.
I can manage.

Regards

Irshad