Solved

fractions in drop down menus

Posted on 2007-12-06
6
390 Views
Last Modified: 2010-04-21
Hi,

Is it possible to format a dropdown box to display fraction values?

If I have a db value of .33, is there a way to express that in a drop down as a fraction?

Thanks

Bill
0
Comment
Question by:billium99
6 Comments
 
LVL 8

Expert Comment

by:kebabs
ID: 20425571
0
 
LVL 6

Expert Comment

by:divyeshhdoshi
ID: 20425605
Yes,
it is possible ,
dropdown treat source value as a text
simply bind it with datavaluefield and datatextfield
0
 
LVL 8

Assisted Solution

by:deadite
deadite earned 200 total points
ID: 20425769
Yes, here is some simple VBScript that will give you a fraction:


MsgBox Dec2Frac(.33)
 
Function Dec2Frac(topPart)
    count = len(topPart) - InStr(topPart, ".")
    mult = 1
    For i = 1 to count
        mult = mult * 10
    Next
    Dec2Frac = (topPart * mult) & "/" & mult
End Function

Open in new window

0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 300 total points
ID: 20426205
billium99,

Create a table:

FrationID      Fraction      FractionValue
1      1      1
2      3/4      0.75
3      1/2      0.5
4      1/4      0.25
5      1/8      0.125

Then you can create your combox to *Display* the fraction but *Use* the Value.

Here is a sample with a table and a sample form:
https://filedb.experts-exchange.com/incoming/ee-stuff/6039-Access--EE-Q23007970--Display-f.zip

JeffCoachman
0
 
LVL 1

Author Closing Comment

by:billium99
ID: 31413347
Hi - both solutions work - the second one is a slightly better fit for this project.

Thanks for the help guys!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 20451445
billium99,

I'm glad we were able to help!
:)

JeffCoachman
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question