ok the fields where fractions will be used are named "width## and Height##"
where ## are numbered 01 to 41. there will be several lines on the order
form where this will be done. the error i get is telling me the number i
enter is to large for the field (5 7/8) the error reads "The Value you
entered isn't valid for this field" "For example, you may have entered text
in a numeric field or a number that is larger then the Field Size setting
permits."

I placed your code in a public module and named it "fractonum"
the field properties are as follows

Name width01
controle source (blank)
Format Scientific
Decimal Places Auto
Input Mask (blank)


"John W. Vinson" wrote:

On Mon, 9 Jul 2007 07:50:01 -0700, KevinKBM
wrote:

OK looks like i won't get the mathmatics i need to work in Access directly.

You CAN get the mathmatics you need to work in Access directly. Did you try my
function? IT WILL WORK.

If you tried and had problems, please post what you did and what problem you
had.

John W. Vinson [MVP]