functions for custom checks

LeeEllen · Post by **LeeEllen** » Thu Jan 25, 2007 11:03 am

I can't find a list of the functions available for editing fields on custom checks - mainly a description of what each function does.

I need a function that will "TRIM" an amount field. I tried TRIM, but it didn't work, so there must be a different function to trim blanks from a numeric.

Can someone help?

Lee-Ellen

Post by **Zaphod** » Thu Jan 25, 2007 11:29 am

A numeric field won't have spaces in it. Are you trying to line up currency fields? If so, there's a setting you want to use to right-align the field. That's a property you set, not a function on the value. Right click on the field to access the properties page. You may actually have to make it a character field in order to right justify it, but that's also a setting you can click.

LeeEllen · Post by **LeeEllen** » Thu Jan 25, 2007 11:43 am

I'm building a text string to go in the info line under the memo line on a custom check. This is what I want to do:

TRIM(DescLine1) + " " + TRIM(Amt2Line1) + ","

When I do this, there is a huge amount of space between the DescLine1 and the Amount - I assumed there were leading spaces in front of the Amt. I would like to see the DescLin1 then one blank space, then the amount then the comma.

Any suggestions for me?

Post by **Zaphod** » Thu Jan 25, 2007 12:34 pm

Ah, try ALLTRIM() instead of TRIM().