Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Month as Header

Status
Not open for further replies.
Poloxstar

Poloxstar

MIS
Jul 10, 2002
11
0
0
US
Hi, does anybody know how to automatically insert monthly headers dynamically by data on a report?
 
Sort by date Sort by votes
Hi poloxstar,

Have you tried changing the header to a textbox with its recordsource based on a feild?

Ian Mayor (UK)
Program Error
Programmers do it one finger at a time!
 
Upvote 0 Downvote
How are Poloxstar . . .

Tying in with [blue]ProgramError[/blue], perhaps an unbound textbox with ControlSource set to:
Code: 
[blue]=Format([Date],"mmmm yyyy")[/blue]

Calvin.gif
See Ya! . . . . . .
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
497
dhookom
dhookom
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
461
JanaLNelson
JanaLNelson
qqp
  • Locked
  • Question
Looking for ideas on how to create an estimating form that would have a header and details under it 1
Replies
2
Views
77
qqp
qqp
v5652
  • Locked
  • Question
Command Button on form header not showing on highlighted bar
Replies
0
Views
34
v5652
v5652
N2Life
  • Locked
  • Question
Last figure in a text box is partially cut off when conditionally formatted as italics 1
Replies
7
Views
69
N2Life
N2Life

Part and Inventory Search

Sponsor

Back
Top