Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bmlkidd

    Conditional Formatting Formula

    Kind of on the same line, we planned on using a chr(13) as a delimeter to tell the field whether to be bold or not. It works, only if there is at least one character on the new line, otherwise, it doesn't bold. Any thoughts? if instr({QuoteDet.Descrip},chr(13)) <> 0 then crbold
  2. bmlkidd

    Extracting remaining paragraph from the first chr(13) from the right

    Thanks, but yes, there can be several returns in this field. The "Can Grow" will suffice. But good tip for the future! Thanks for the help!
  3. bmlkidd

    Extracting remaining paragraph from the first chr(13) from the right

    Sorry guys - said I was a newbie. Found the "Can Grow" check box. Thanks for the help!
  4. bmlkidd

    Extracting remaining paragraph from the first chr(13) from the right

    Never mind - stupidity on my part is reigning this morning. Embarrassed to say that I merely didn't have the field sized to encompass all of the text. Isn't there an AutoSize of some sort for fields in a report?
  5. bmlkidd

    Extracting remaining paragraph from the first chr(13) from the right

    Thanks for the quick response. Yes, my first attempt was as follows: right({QuoteDet.Descrip}, length({QuoteDet.Descrip})- InStr({QuoteDet.Descrip}, chr(13))) However, it left the field blank. I should note there are multiple character returns in the paragraph, but again, worked fine in VB ...
  6. bmlkidd

    Extracting remaining paragraph from the first chr(13) from the right

    Newbie - be gentle ... This works fine: left({QuoteDet.Descrip},instr({QuoteDet.Descrip},chr(13))) This does NOT: local numbervar x; local numbervar y; x := instr({QuoteDet.Descrip},chrw(13)); y := length({QuoteDet.Descrip}); right({QuoteDet.Descrip},y - x ) IT works fine in VB, why not...

Part and Inventory Search

Back
Top