I have a combo box with 2 selections to choose from. Next to the cbo is a
text box. Entries in both boxes will add a record to their respective
control-source fields in the main table.
If "selection1" is chosen in the cbo, I want the user's entry in the text box
to be limited in format to a six-digit number (most likely with zero's in one
or more of the first characters).
If "selection2" is chosen in the cbo, I want the user's entry in the text box
to be limited in format to a six-digit number with the possibility of one to
two decimal places as well (with the decimal point being displayed in the txt
box for convenience).
Can anyone help with example of code that would allow me to do this?
Thanks very much in advance!
text box. Entries in both boxes will add a record to their respective
control-source fields in the main table.
If "selection1" is chosen in the cbo, I want the user's entry in the text box
to be limited in format to a six-digit number (most likely with zero's in one
or more of the first characters).
If "selection2" is chosen in the cbo, I want the user's entry in the text box
to be limited in format to a six-digit number with the possibility of one to
two decimal places as well (with the decimal point being displayed in the txt
box for convenience).
Can anyone help with example of code that would allow me to do this?
Thanks very much in advance!
