That depends... do you want Access to merely "accept" a string of
characters, or will you be wanting to "do math" on the value that string of
characters represents?

If the latter, one way to do this would be to build a function that takes a
"text" input (e.g., "1/5") and converts it to a decimal equivalent.  Access
can "do math" on the decimal equivalent.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I don't mind wheter Access accept in Text or Number, as long as Acces can do
calculation. So when the user enter the price, that price should be in
fraction. Then Access has to convert it in decimal or whatever, so we can
calculate that field when we need it.

Thanks for your help.

KF