Newbies Confused Posted February 20, 2001 Newbies Posted February 20, 2001 Hi group. Hope someone can help me with this. I'm designing a layout which has numerous fields, most of which have defined value lists. I'm trying to get it so I can merge them onto a pre-written form letter. They need to be such that there are commas between words and periods after sentences. My fields are such that the user may need to choose more than one value. I've placed the <<merge>> parentheses in the appropriate location, but cannot pre-place commas because the fields may not always have values. Any suggestions on using merged fields more efficiently? Regards, Confused
john.daly Posted February 20, 2001 Posted February 20, 2001 This is always a difficult one! The only way around it that I have found is to have calculated fields for the commas. e.g; Comma 1: If(Field 1 = "", "" , ", ") Comma 2: If(Field 2 = "", "" , ", ") etc. Not very neat but it will work.
Recommended Posts
This topic is 8930 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now