Results 1 to 2 of 2
  1. 01-15-2010, 10:27 AM #1
    techexpressinc's Avatar
    techexpressinc
    techexpressinc is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    replace a empty field with the word "none" how??

    i am trying to get when the field is not loaded spaces or null to replace it with the word none.



    IIf([Notes]=" ","None",[Notes]) AS NOTES2,
    IIf([Notes]=Null,"None",[Notes]) AS NOTES3


    I do not see data in the field. And sometimes NOTES2 gets the word "None" sometimes not??

    Never the NOTES3 gets "None".


    Rneuman @ scaninc.org
    Reply With Quote Reply With Quote
  2. 01-15-2010, 11:02 AM #2
    techexpressinc's Avatar
    techexpressinc
    techexpressinc is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    answer

    IIf(IsNull([Notes]),"None",(IIf([Notes]=" ","None",[Notes])))
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. "Add a new field" form
    By vCallNSPF in forum Forms
    Replies: 2
    Last Post: 02-10-2010, 09:56 PM
  2. Error message and How do I find the "value Field" ?
    By createdwithfire in forum Forms
    Replies: 1
    Last Post: 11-05-2009, 12:26 PM
  3. aSTR = Dir("C:\*.*") >> "Type Mismatch"
    By JGrant in forum Programming
    Replies: 1
    Last Post: 03-28-2009, 05:17 AM
  4. Counting "true" checkboxes and ignoring "fals
    By hraup in forum Reports
    Replies: 2
    Last Post: 08-31-2006, 12:19 PM
  5. "Count" and "Countif" in Reports
    By JMantei in forum Reports
    Replies: 1
    Last Post: 06-20-2006, 02:20 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums