Storing Values Created from an Input Mask

[Eka1618]

Hello,

I have a field that can either except a single value or a range. What I have
done is create two textboxes on my form who's control source is the same
(L_HARD_VALUE). In one text box, an input mask is set to accept a range, the
other accepts regular text.

When a combo box is click it will signal which textbox to use for this
field, so if the combo box value is "Range" then that textbox will be active,
else the other will be active.

I want to beable to store the range as a range. The field's data type is
Text, but when I use it, it leaves out the other characters that are in
place. For instance, if the range is "456 to 555" the value stored for that
field is: 456555

Everything seems to work, minus how it is stored in the table. Is there
anyway to store the range as it is shown above in the table without making
the field have an input mask?

Here is the syntax for the input mask: !###" to "###;;_

I would really prefer not to have to create an additional field, but I do
not know how to get past this issue. If anyone has any suggestions, please
let me know. Thank You!

 

[Eka1618]

I solved my problem, I didn't check the option to have the characters store
in the table. If anyone is wondering where you can mark it, it's in the input
mask wizzard.