?
Solved

Need to replace {MERGEFIELD} Boolean with CHECKMARK symbols....

Posted on 2006-04-03
12
Medium Priority
?
664 Views
Last Modified: 2009-07-29
Hi,

I have some Boolean Fields I'm importing from Access that are returning -1, 0 values.  I want to write my MergeField so that it exchanges a -1 (true) value for a Checkmark Symbol.

Can I do this in the MergeField itself or do I need to do a For Each...Next Loop to replace them on the open?

M
0
Comment
Question by:MitchellVII
  • 6
  • 6
12 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 16366231
You can wrap the mergefield with an IF field and do Insert symbol.

Select the mergefield << Maybe >> and press Ctrl+f9
You should then look like this

{ << Maybe >> }

You can then insert the IF, test and the symbol(s):

{ IF << Maybe >> = -1 &#8730; X }


0
 
LVL 5

Author Comment

by:MitchellVII
ID: 16366618
I cant see to get that to work.
0
 
LVL 5

Author Comment

by:MitchellVII
ID: 16366707
Ok I got it to work, I just neede to insert the symbol directly into the formula from the menu.  works great now :)
0
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

 
LVL 76

Accepted Solution

by:
GrahamSkan earned 2000 total points
ID: 16405185
Form Fields and Mail Merge are not really compatible. To for a form document to work properly, it must be protected. This prevents it from being used as main document in mail merge.

You can show a symbol, depending on the value of a merge field (although it doesn't show successfully in a browser):

http://www.experts-exchange.com/Applications/MS_Office/Word/Q_21800195.html
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 16405190
Sorry, Mitchell, I meant to refer to this question, not post a comment in it.
0
 
LVL 5

Author Comment

by:MitchellVII
ID: 16405978
Hey Graham,

I've broken down, after all this, and just decided to create a web page to gather the information.  It has been a steep learning curve but it is almost done.  Basically I just created my form in word, saved it as a web page then opened it in Dreamweaver and plugged in fields.

Now the data is just emailed to me.  Pretty cool actually.  The web page should be up tomorrow, I'll link you to it for grins.
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 16406232
Thanks Mitch. I'll look forward to it.
0
 
LVL 5

Author Comment

by:MitchellVII
ID: 16412402
Hey Graham,

Here's the finished (well close anyway) product.  Much learning curve sweat and toil here but I think I have it.

Right now my form is sending me a TXT email with all the data in it.  Next step will be to figure out how to use PHP to write all this directly to a database.

Anyway, here's the link to my main website and you can navigate to the form from there...

http://www.executivedecision.biz/

M
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 16413489
That looks good.
Shame I'm too old & in the wrong country to apply.
0
 
LVL 5

Author Comment

by:MitchellVII
ID: 16413498
Thanks,

How old are you?  I'm 45 (ack)

Do you think the font is too small?  I personally HATE large fonts on forms, but I don't want it to be too small to read.

Also, does the opening web page look ok?  It isn't much, just a business card really.
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 16413613
It's 22 years since I was 45. But as they say about old age - it's not so bad when you consider the alternative.

The same can be said for the font size. I think it's OK. Any bigger and you'd be scrolling up and down, and losing the place.

I think that the opening page conveys an appropriate professionalism.

0
 
LVL 5

Author Comment

by:MitchellVII
ID: 16413651
Ah cool.

You know, I would have NEVER guessed you to be 67, not that that is particularly old, but you come across as quite youthful.  Rarely in my travels have I met someone quite so knowledgeable and helpful.

I kind of miss it over here - a couple of the "Experts" over on the HTML side are really arrogant jerks and love to make insulting comments about new ideas on doing a web page.

One fellow over there savaged my new pages saying they all had too small text, it wasn't good to have the text fields hidden, i should have a click noise when you enter a text field, blah, blah, blah.

I guess I need to be designing my page for those people with 14 inch screens running Windows 97?  Lol.

Anyway, thank again :)
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question