Web Development



Help with Access Queries?

By pdx9944 ·
Workign with Access 2007 queries -
Currently working in query>design view the field works but in the output it is bringing in div tags.
Test Notes: IIf([Notes]="",[Location],[Location] & " " & [Notes])

example of output field: Chicago <div>Bus Driving over the line.</div>
Correct output should be: Chicago Bus Driving over the line.
Any ideas? .

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Possibly your formatting

by Andrew Marr In reply to Help with Access Queries?

Try this:

Right click on your specified field, view property sheet then change text format to Rich Text.

Collapse -

Reponse To Answer

by pdx9944 In reply to Possibly your formatting

Hi Andrew, I have changed text format before, i have to run this query 20 times per day and I don't want to have to change the format everytime I run it. I heard there might be another way perhaps:
Though, I am not sure how to add it to:
I might off-base and unrealistic.


Related Discussions

Related Forums