How can I set the caption of a form to a textbox value. I want the caption to change as the records change.<br><br>Ex: txtJobNumber = 00-100<br><br> Form Caption: Job Number: 00-100<br><br> txtJobNumber = 00-101<br><br> Form Caption: Job Number: 00-101<br><br>Thanks to all<br><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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Custom Form Caption
- Thread starter ind
- Start date
Cornerstone
MIS
use the forms on Current Event and add this code:<br><br>Form.Caption= "Job Number: " & txtJobNumber
Simple, under the On Current property of your form, go into the Code Builder (just click on the "..." and choose Code Builder), then put in the VB code:<br><b><br>Me.Caption = "Job Number " & Me.[Job Number]<br></b><br><br>You can just cut and paste this formula in there, if your actual field name is "Job Number" otherwise change it to your actual field name. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
Correction, you may have to use the formula<br><b><br>Me.Caption = "Job Number " & Me.Job_Number<br></b><br><br>I avoid spaces in my field names, so i'm not positive which way it should be.<br> <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Helpful tip
- Locked
- Question