Single Character Fractions

[razorking]

Does anyone have any information on using Single Character fractions in Access reports using data from a table or query?

So, I f I have data like 12 1/2 X 12 1/2 it will appear as 12 ½ X 12 ½ on the report?

 

[boblarson]

you can use the replace function to replace 1/4 with Chr(188), 1/2 with Chr(189), and 3/4 with Chr(190) but those are the only ones available.

 

[razorking]

you can use the replace function to replace 1/4 with Chr(188), 1/2 with Chr(189), and 3/4 with Chr(190) but those are the only ones available.

Can you show a basic example of how I might use the rplace function to do this?

Also, is it possible somehow to create/add custom/user defined characters?

 

[razorking]

I see/understand how to use the replace function.

Would still be interested in finding out if it is possible to add custom characters for the less common fractions (5/8, etc)

Also, would it be possible to construct a form to use for the repalce operations? For example: a simple form with to text boxes, one to type in the text to find and the other to type in the replacement text, then a button to run. Trying to find an easy way for a user to do find/replace on a field in a table - where there are several different things in a string to be replaced.

 

[boblarson]

Unless you create your own Font and then install it to each computer that would need to see it, there isn't a way to do it with any but those three characters I shared.

If you did have your own font created and used those you could use a combo box to select what you wanted.

 

[razorking]

I did figure out that if I open Word I can go to the Insert tab (Office 2007 or 2010) and then go to symbols/More Symbols there are quite a few more fractions in there. And these can be copied from a Word document and used in find/replace function in Access.