Report Caption

[Scott Duncan]

We are printing our Invoices to a pdf writer...

We would like to change the caption of the report to the Invoice Number to
eliminate
DB operator errors...

Tried:

Private Sub Report_Open(Cancel As Integer)
Me.Report.Caption = "Invoice " & Report.[InvoiceNumber]
End Sub


We get runtime error 2427 'Expression has no value'

Any thoughts would greatly be appreciated.

TIA,

SD

 

[Carl Rapson]

Instead of Report_Open, try putting it in the Report_Page event.

Carl Rapson

 

[Scott Duncan]

It works...

Thank you !

SD

Instead of Report_Open, try putting it in the Report_Page event.

Carl Rapson

We are printing our Invoices to a pdf writer...

We would like to change the caption of the report to the Invoice Number
to eliminate
DB operator errors...

Tried:

Private Sub Report_Open(Cancel As Integer)
Me.Report.Caption = "Invoice " & Report.[InvoiceNumber]
End Sub


We get runtime error 2427 'Expression has no value'

Any thoughts would greatly be appreciated.

TIA,

SD

 

[Carl Rapson]

You're welcome. This is the first time I've been able to help someone -- it
feels great!

Carl Rapson

It works...

Thank you !

SD

Instead of Report_Open, try putting it in the Report_Page event.

Carl Rapson

We are printing our Invoices to a pdf writer...

We would like to change the caption of the report to the Invoice Number
to eliminate
DB operator errors...

Tried:

Private Sub Report_Open(Cancel As Integer)
Me.Report.Caption = "Invoice " & Report.[InvoiceNumber]
End Sub


We get runtime error 2427 'Expression has no value'

Any thoughts would greatly be appreciated.

TIA,

SD

 

[Duane Hookom]

Way to go Carl! Kinda fun ain't it?

--
Duane Hookom
MS Access MVP
--

You're welcome. This is the first time I've been able to help someone --
it feels great!

Carl Rapson

It works...

Thank you !

SD

Instead of Report_Open, try putting it in the Report_Page event.

Carl Rapson

We are printing our Invoices to a pdf writer...

We would like to change the caption of the report to the Invoice Number
to eliminate
DB operator errors...

Tried:

Private Sub Report_Open(Cancel As Integer)
Me.Report.Caption = "Invoice " & Report.[InvoiceNumber]
End Sub


We get runtime error 2427 'Expression has no value'

Any thoughts would greatly be appreciated.

TIA,

SD