Results 1 to 4 of 4
  1. #1
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568

    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
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    True is -1 in Access NOT 1

    Do you use ; instead of , to separate each part of the IIf expression in Poland?
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    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
    568
    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, 12:12 PM
  2. Replies: 3
    Last Post: 04-20-2016, 02:50 PM
  3. Suppress "Error" message following "Cancel = True"
    By GraeagleBill in forum Programming
    Replies: 7
    Last Post: 03-23-2014, 05:40 PM
  4. Replies: 30
    Last Post: 09-27-2013, 01:34 PM
  5. Replies: 2
    Last Post: 08-31-2006, 12:19 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