C
Chris
In hopes someone can shed some light . . .
A field is currency type in the table and formatted there and in the control
as "00 0000".
The control displays properly except when clicking into the combo box. I do
have on focus code to change color but cannot see that as an impediment to
formatting as above. What I get displayed on clicking into the box is not
"07 2358" but "72358".
Research indicated the following code, but it won't work for me.
Forms![frm1 Client].Form![Jobfrm].Form![cboFindJob].Format = "00 0000"
As you can see, the control is on a subform.
Can someone see something wrong in my code -- or ability to accomplish?
A field is currency type in the table and formatted there and in the control
as "00 0000".
The control displays properly except when clicking into the combo box. I do
have on focus code to change color but cannot see that as an impediment to
formatting as above. What I get displayed on clicking into the box is not
"07 2358" but "72358".
Research indicated the following code, but it won't work for me.
Forms![frm1 Client].Form![Jobfrm].Form![cboFindJob].Format = "00 0000"
As you can see, the control is on a subform.
Can someone see something wrong in my code -- or ability to accomplish?