Results 1 to 5 of 5
  1. #1
    PeterS is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    45

    Form fields usind decimals

    Just a quick question....



    I have split my database successfully and it is working wonderfully thanks to everyone on the forum...THANK YOU EVERYONE.

    The only problem I am having is prob simple...

    I have the front end of my DB on 6 pc's, all performing data capture through forms and everything is working 100% except one PC.

    The field in the table is a number field formated as Double and the decimal is set on 2

    All the pc's except one can capture the decimal. Why is only one pc giving me a problem?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    set the textbox format to FIXED, 2

  3. #3
    PeterS is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    45
    Thanx ranman.....I did what you said but no change. That pc still gives the following error:
    The value you have entered isn't valid for this field.
    For example, you may have entered text in a numeric field that is no larger than the field settings permits.

    All the other pc's are 100%

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    ?????
    makes no sense!

  5. #5
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I would try:

    On the PC that is having troubles (call it PC1), delete that FE.
    Copy a FE from a PC that is working correctly to the other PC (PC1).

    Maybe there is corruption in that FE or someone was snooping in the FE and changed something or that FE is an earlier version or .

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

Similar Threads

  1. Include Decimals when Adding Fields
    By janmack79 in forum Queries
    Replies: 3
    Last Post: 04-24-2017, 02:01 PM
  2. How to hide decimals in the form field
    By azhar2006 in forum Forms
    Replies: 20
    Last Post: 01-25-2014, 01:40 PM
  3. Rounding decimals
    By brianmcleer in forum Access
    Replies: 1
    Last Post: 06-05-2013, 12:37 PM
  4. Age with Decimals?
    By Lowell in forum Access
    Replies: 1
    Last Post: 10-18-2012, 11:13 PM
  5. Round Up/Down 4 Decimals to 2
    By newbie in forum Access
    Replies: 6
    Last Post: 10-18-2010, 02:58 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