Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

IIF with (chr(13))

Discussion in 'Information Technology' started by Boots, Jul 28, 2006.

Tags:
  1. Boots

    Boots
    Expand Collapse
    Guest

    Is it possible to put char code (Chr(13)) in an IIF statement. In a report I
    am making I want to put one comment if the condition is true and two lines of
    comments if the condition is false

    thanks
     
  2. Loading...

    Similar Threads Forum Date
    India IIFA 2014: ‘Bhaag Milkha Bhaag’ wins 9 technical awards! Breaking News Mar 5, 2014

  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    I'm not sure if that what you mean, but to join two comments with a new line
    try

    IIf(Condition = True, [Comment1] , [Comment1] & Chr(13) & Chr(10) &
    [Comment2])

    --
    Good Luck
    BS"D


    "Boots" wrote:

    > Is it possible to put char code (Chr(13)) in an IIF statement. In a report I
    > am making I want to put one comment if the condition is true and two lines of
    > comments if the condition is false
    >
    > thanks
     

Share This Page