Access Reports

emady

Board Regular
Joined
Feb 19, 2003
Messages
228
Hi,

I have a report and in its Detail_Print event I have the following code:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

With Me!txtNodeName
.FontWeight = Bold
.FontItalic = True
.LeftMargin = 0.75
End With

End Sub

For some reason when the report runs it only sets the font to Italic and ignores the Bold and LeftMargin properties.

I tried placing the code in different events but had a similar result.

Can anyone explain why this is happening?

:oops: :oops: :rolleyes: :rolleyes: :rolleyes: :oops: :oops:
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
I dont think that you can set the margin in a text box in Access (at least not in A97)
For Bold use
.FontBold = True


HTH

Peter
 
Upvote 0
Thanks Peter,
That worked fine. As for the margins, you can set them in Access2000, the trick turned out to be that the value passed is in pixels so my 0.75 wouldn't actually show :)

Thanks,
Elia
 
Upvote 0

Forum statistics

Threads
1,221,657
Messages
6,161,084
Members
451,684
Latest member
smllchng5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top