Inches and feet symbols

  • Thread starter Thread starter TeeSee
  • Start date Start date
T

TeeSee

Something I would like to clarify once and all before I remove all
symbols fro my descriptions.

I have numerous descriptions containing dimensions e.g. Board 2" x 24"
x 48" or Roll 125" x 500'. When handling these as strings I obviously
run inti string errors.

My question is "is there any foolproof way of handling this other than
removing all the " and ' characters.

Thanks
 
TeeSee,
I would use two fields for each value.
Length and LengthUM
Width and WidthUM
Height and HeightUM Etc... as needed...
Sample values might be...
Length LengthUM
6 Ft
or
10 In etc....
The UM values could be check boxes, or a listbox , to make selection
easy.
Now those values are enetered and viewed that way on the form, but...
on any report, you could convert the Ft to ' , or the In to ", and
concatenate that with the value...
=Length & "'"
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top