Alpha Video Training
Results 1 to 2 of 2

Thread: Percent Format?

  1. #1
    Member Lawrence Fox's Avatar
    Real Name
    Lawrence Fox
    Join Date
    Jun 2003
    Location
    Thornhill, ON Canada
    Posts
    120

    Default Percent Format?

    I have a numeric field that records a sales tax rate. Right now, users enter "0.07" for seven percent. Is there a way of formatting the field so that they see "7%" (or "8.56%") when entering data and Alpha is "smart enought" to store it as 0.07 or 0.0856?

    The standard "percent" format simply displays something like "0.07%" which isn't what I want.

    Yes I do realize that the alternative is let users enter 7.00 and for me to divide by 100 whenever I actually use the sales tax rate :). I was just wondering if there was another way around....
    Last edited by Lawrence Fox; 12-15-2005 at 02:15 AM.
    Lawrence Fox
    ComputerWizard Consulting
    http://www.computerwizardonline.com
    Bookkeeping, Accounting & Database Design
    "Nobody goes to work for themselves in order to do paperwork--so call the Wizard today and get back to doing what YOU love to do..."

  2. #2
    "Certified" Alphaholic
    Real Name
    Ed Barley
    Join Date
    Mar 2002
    Location
    Southern California
    Posts
    1,056

    Default An idea

    Hi Lawrence

    Here is one idea. Please look at the zip file attached. You could also use a calculated field on the form, etc.

    Good Luck

    Ed

Similar Threads

  1. How to display a field as a percent
    By David Francis in forum Alpha Five Version 4
    Replies: 3
    Last Post: 08-12-2004, 06:49 AM
  2. percent field format
    By bruce in forum Alpha Five Version 5
    Replies: 0
    Last Post: 12-04-2003, 10:00 PM
  3. statusbar.percent(i, count)
    By William Perry in forum Alpha Five Version 5
    Replies: 2
    Last Post: 01-14-2003, 01:35 PM
  4. statusbar.percent()
    By Jeff Moses in forum Alpha Five Version 4
    Replies: 7
    Last Post: 04-04-2001, 10:23 AM
  5. Percent of Counts in Reports
    By Chris.Tanti in forum Alpha Five Version 4
    Replies: 14
    Last Post: 06-15-2000, 12:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •