Formating a field

[Jtrader]

Is it possible to format a field to display fractions?

I want to enter my values using decimals (10.5), but have the record read 10 1/2. Tried "number format" in layout mode but fractions aren't an option.

Running FMP6, but have access to FMP7 if needed.

Thanks

[BobWeaver]

There is no built-in numeric format to display as fractions. You can create a text calculation to do this though. Have a look at these threads:

http://www.fmforums.com/threads/showflat...=true#Post90627

http://www.fmforums.com/threads/showflat...true#Post114420

http://www.fmforums.com/threads/showflat...true#Post152811

[Jtrader]

Thanks for the help Bob.

[Jtrader]

I'm still having a little trouble doing this. If it isn't much trouble can someone take a look at the attached example to see if what I'm trying to do is possible?

Thanks

Sample.zip

[BobWeaver]

See attachment.

For field L, I created a calculated display field Ldisp which shows fractions, and placed it over top of field L, so when finished entering data in L, Ldisp contents show instead. You can repeat the same for the other fields.

The display fields' formatting should be set to not allow entry.

Sample.fp5.zip

[Jtrader]

Outstanding Bob! This is very helpful.

Thanks, J