Report Caption

  • Thread starter Thread starter Scott Duncan
  • Start date Start date
S

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
 
It works...

Thank you !

SD

Carl Rapson said:
Instead of Report_Open, try putting it in the Report_Page event.

Carl Rapson

Scott Duncan said:
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
 
You're welcome. This is the first time I've been able to help someone -- it
feels great!

Carl Rapson

Scott Duncan said:
It works...

Thank you !

SD

Carl Rapson said:
Instead of Report_Open, try putting it in the Report_Page event.

Carl Rapson

Scott Duncan said:
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
 
Way to go Carl! Kinda fun ain't it?

--
Duane Hookom
MS Access MVP
--

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

Carl Rapson

Scott Duncan said:
It works...

Thank you !

SD

Carl Rapson said:
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
 
Back
Top