Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

I have an Access 2016 form that con

I have an Access 2016 form that con

I have an Access 2016 form that con

I have an Access 2016 form that converts and displays a mm entry to inches. Is it possible to have the decimal portion displayed in "eights"?
I have been working on this issue for a week and the closest to a possible solution might be the DecimalToFraction function.
All help very much appreciated.
Note: I am new to this group so not certain if the question is allowed.
If not I apologize.

RE: I have an Access 2016 form that con


This is a Crystal Reports forum. It looks to me that what you need is an Access solution rather than a Crystal Report solution.

There are Tek-Tips forums for questions relating to Access Forms and Access Reports (and other Access issues). If it is an Access solution you are looking for I'd suggest you use the Forum Search functionality at the top of the Tek-Tips home page and post the question there.

If however you are looking for a Crystal Reports solution and I understand the problem correctly (ie display a decimal such as "7.25" inches as "7 2/8"), I did it like this:


Local NumberVar a;
Local NumberVar b;

a := Truncate({Decimal_Value});
b := {Decimal_Value}- a;

ToText(a, '#') + ' ' + ToText(Round(b * 8, 0), '#') + '/8' 

Not sure it will help, but even if you are trying to do something in Access you may be able to adapt this formula.

Regards, Pete

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close