I create form every month where a series of activities are enter. I like the form to display title as such "LOGS FOR NOVEMBER 2000". Can anyone give me any sugestions.<br> <p>Villica<br><a href=mailto:villica67@hotmail.com>villica67@hotmail.com</a><br><a href= > </a><br>
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!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
HOW DO I MAKE A FORM SHOW THE DATE 1
- Thread starter villica
- Start date
-
1
- #2
Use the On Open event of your form:<br><br>Private Sub Form_Open(Cancel As Integer)<br>Me.Form.Caption = "LOGS FOR " & UCase(Format(Now(), "mmmm yyyy"
)<br>End Sub<br><br>HTH<br>RDH <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>
)<br>End Sub<br><br>HTH<br>RDH <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>- Thread starter
- #3
The result of the previous post will be only the month and year. The poster wanted this example: "LOG OF NOVEMBER 2000". So you will have to concatenate "LOG OF " then use the UCase Function to make the result of the Format Function all Capital letters. Thus you end up with:<br><br>"LOGS FOR " & UCase(Format(Now(), "mmmm yyyy")<br><br>Just thought I'd explain.<br><br>RDH <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>
)<br><br>Just thought I'd explain.<br><br>RDH <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question