Re: fraction number format?

On Fri, 30 Jun 2006 16:47:52 GMT, Richard Hollenbeck wrote:

How can a numeric field display results in fractions? If my recipe data
requires 1/2 cup of something, for example, I'm willing to punch in 0.5 in
the quantity field then select cup in the unit field, but it is more
aesthetically cool to display the number like any paper cook book would--in
plain old regular fractions. I didn't see a format to select to show
fractions. Excel has no problem displaying fractions. Any ideas?

Thanks.

Access does not support 1/2 as a number. Either use 0.5 instead or
make the field a Text datatype, which will not allow easy recipe
doubling.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Relevant Pages

  • Re: fraction number format?
    ... the quantity field then select cup in the unit field, ... plain old regular fractions. ... them to decimals for storage through a hidden bound text ...
    (comp.databases.ms-access)
  • fraction number format?
    ... How can a numeric field display results in fractions? ... If my recipe data ... requires 1/2 cup of something, for example, I'm willing to punch in 0.5 in ...
    (comp.databases.ms-access)