Results 1 to 4 of 4

Change 1 to "true"

  1. #1
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    563

    Change 1 to "true"

    Hi,



    in postgres i have bolean and there is true or false.
    In access i see this as 1 or 0.

    How can i change it on form?
    I tried with default value (=IIf([CurrentVersion]=1;"true";"false")) but it is not working.

    thank you,
    Jacek

  2. #2
    ridders52's Avatar
    ridders52 is offline Voodoo Is Practised
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    2,397
    True is -1 in Access NOT 1

    Do you use ; instead of , to separate each part of the IIf expression in Poland?
    Colin (Mendip Data Systems), Website, email
    If this has helped, please click the star button and leave a comment

  3. #3
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    563
    o wow

    this is a strange.
    In postgresql i have:

    Click image for larger version. 

Name:	Screenshot_26.png 
Views:	10 
Size:	38.5 KB 
ID:	34718

    and in Access it is converted in linked table as text ! ...

    hmm

    Best,
    Jacek

  4. #4
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    563
    If will be working ridders52.

    I checked in odbc option Bools as Char to false and True is -1 as true.

    But still is not working.

    Best,
    Jacek

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

Similar Threads

  1. Replies: 3
    Last Post: 07-28-2017, 11:12 AM
  2. Replies: 3
    Last Post: 04-20-2016, 01:50 PM
  3. Suppress "Error" message following "Cancel = True"
    By GraeagleBill in forum Programming
    Replies: 7
    Last Post: 03-23-2014, 04:40 PM
  4. Replies: 30
    Last Post: 09-27-2013, 12:34 PM
  5. Replies: 2
    Last Post: 08-31-2006, 11:19 AM

Posting Permissions

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