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

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
LVL 5
MitchellVIIAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GrahamSkanRetiredCommented:
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
MitchellVIIAuthor Commented:
I cant see to get that to work.
0
MitchellVIIAuthor Commented:
Ok I got it to work, I just neede to insert the symbol directly into the formula from the menu.  works great now :)
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

GrahamSkanRetiredCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GrahamSkanRetiredCommented:
Sorry, Mitchell, I meant to refer to this question, not post a comment in it.
0
MitchellVIIAuthor Commented:
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
GrahamSkanRetiredCommented:
Thanks Mitch. I'll look forward to it.
0
MitchellVIIAuthor Commented:
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
GrahamSkanRetiredCommented:
That looks good.
Shame I'm too old & in the wrong country to apply.
0
MitchellVIIAuthor Commented:
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
GrahamSkanRetiredCommented:
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
MitchellVIIAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.