Format Report Caption

[OOzy]

I am trying to format the report caption to look like

20051109 - Action Items
YYYYMMDD - Action Items

using the code below but I am getting a compile error:can't find project or library. Also the word Format gets highlighted

Please help!

Private Sub Report_Open(Cancel As Integer)
Dim RC As Variant

RC = [highlight]Format[/highlight](Now(), "YYYYMMDD") + "-Action Items"

Report.Caption = RC
End Sub

 

[THWatson]

OOzy
The Format part is correct. To check that, just use your code without the + "(-Action Items)" part.

I think your problem lies with that piece of the line. Try changing the + sign to an ampersand (&).
RC = Format(Now(), "YYYYMMDD") + "-Action Items"

RC = Format(Now(), "YYYYMMDD") & "-Action Items"

or
RC = Format(Now(), "YYYYMMDD") & ( + "-Action Items")
if you want this to go away if null.


Tom

 

[dhookom]

I think this is a references issue. If Tom's suggestion doesn't work, check this link

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Remou]

This topic also appears at:
Format Report Caption
thread705-1148944