Results 1 to 2 of 2
  1. #1
    msasan1367 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    60

    comma-separate for fee

    how to separate numbers in a textbox with comma?
    for example: when I enter 3000000 in textbox and go to another field, it converts to 3,000,000
    thanks



    Find it:
    just need to create currency data type in table, and put its format at "standard" and its decimal places at "0"
    Last edited by msasan1367; 05-29-2013 at 02:41 AM.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Thanks for posting back with your solution.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. comma in a query
    By jscriptor09 in forum Access
    Replies: 1
    Last Post: 05-18-2012, 04:18 PM
  2. VBA excluding (Ignoring) Comma
    By RedWolf3x in forum Programming
    Replies: 3
    Last Post: 11-11-2011, 05:15 PM
  3. Comma
    By tmcrouse in forum Queries
    Replies: 4
    Last Post: 10-11-2011, 04:33 PM
  4. Replies: 6
    Last Post: 06-15-2011, 11:48 AM
  5. Parsing A Comma Delimited Field
    By AccessGeek in forum Import/Export Data
    Replies: 6
    Last Post: 02-03-2011, 01:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums