need input mask

  • Thread starter Thread starter eb1mom
  • Start date Start date
E

eb1mom

I am searching for an input mask to display
feet/inches/fraction. I would like result to appear xxFt.
xxIN. 1/2 or something close to that. Is there a list of
input mask examples anywhere? Thanks
 
I am searching for an input mask to display
feet/inches/fraction. I would like result to appear xxFt.
xxIN. 1/2 or something close to that. Is there a list of
input mask examples anywhere? Thanks

What's the underlying field, and whence is it derived? A number like
73.5 (6Ft 1In 1/2)? If so a Mask will NOT do it - they are of very
limited capability and certainly cannot do arithmatic operations.
You'll probably need a custom VBA function to translate the number
into a string... and a fraction like 73.134123 is going to come out as
a very wierd fraction!
 
The underlying field is a text field labeled length. This
field, at this point in time is not used for calculations.
This is user typed in field for the finished length of
product. Field is now used only in a monthy report from
this form. I am trying to find some way that all users
would enter informaion in same format. Some enter 2 feet 2
inches, others enter 2ft 2in, others 2' 2". I like the look
of your 73.5 inches, and then we could use length in
calculations. Maybe an input mask isn't what I need? Thanks
 
Your problem stems from a poor design of the data entry syetem! Add another
textbox and then enter feet into the first textbox and inches into the second
textbox. Now if you want you can put an input mask on each. If you want to
display the length you can use:
[FeetTextBox] & "' - " & [InchesTextBox] & """"""


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
 
The underlying field is a text field labeled length. This
field, at this point in time is not used for calculations.
This is user typed in field for the finished length of
product. Field is now used only in a monthy report from
this form. I am trying to find some way that all users
would enter informaion in same format. Some enter 2 feet 2
inches, others enter 2ft 2in, others 2' 2". I like the look
of your 73.5 inches, and then we could use length in
calculations. Maybe an input mask isn't what I need? Thanks

Not for that purpose, no! Unfortunately, Access won't easily let users
type in familiar 6'1 1/2" and actually store 73.5, or vice versa. I
guess you COULD use an input mask of

90"Ft "90 9/9"in"

on your Text field, but this would give you wierd things like

6Ft 0 / in

and would restrict some desired input.

Heretical suggestion: have them enter 186.69 cm instead... <g>
 
Thanks for you help. I like the centimeter suggestion,
would be great for calculations. Two text boxes makes sense
for feet - inches. However I am positive users are not
ready for metrics and if I put TWO text boxes on form it
would take at least a week of retraining. Form text box has
a large label above it with the length format my boss wants
to see and still get bad entries. Perhaps I should just
make a combobox with every length possibility and have them
pick. :-) I'll show my boss your comments and suggestions.
 
Thanks for you help. I like the centimeter suggestion,
would be great for calculations. Two text boxes makes sense
for feet - inches. However I am positive users are not
ready for metrics and if I put TWO text boxes on form it
would take at least a week of retraining. Form text box has
a large label above it with the length format my boss wants
to see and still get bad entries. Perhaps I should just
make a combobox with every length possibility and have them
pick. :-) I'll show my boss your comments and suggestions.

Maybe just use two textboxes with 'ft' and 'in' labels, and use an
input mask of 990 on the ft, 90.000 on the inch, and force them to
enter fractions as decimals. Put the .125/.25/.375 etc. for eighths on
a label.
 
Back
Top