I have a text box on mu report that is bound to a numeric field in my table. The reason this feild is set to numeric is so that we can calculate the total amount of time a job will be in a department. I need to be able to put an "X" in this box to show that the job is done. I need to know how to change the format of the text box to string instead of numeric if a box is clicked on my form.
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!
Format Properties
- Thread starter Rjconrep
- Start date
If you want to just change it on the form......
Put this code in the AfterUpdate event of the check box:
If Me![nameofcheckboxfield] = True Then
Me![nameoffieldwithnumber].Format = ""
Me![nameoffieldwithnumber] = "X"
Else
Me![nameofformat].Format = "Long Integer"
End If
Or something much like that.... Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)
Robert L. Johnson III, MCSA, CNA, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com
Put this code in the AfterUpdate event of the check box:
If Me![nameofcheckboxfield] = True Then
Me![nameoffieldwithnumber].Format = ""
Me![nameoffieldwithnumber] = "X"
Else
Me![nameofformat].Format = "Long Integer"
End If
Or something much like that.... Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)
Robert L. Johnson III, MCSA, CNA, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
