Question

Locked

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.

3 total posts (Page 1 of 1)  
| 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:
ex:Replace((Replace([Notes],"<div>","")),"</div>","")
Though, I am not sure how to add it to:
left([right([Notes],instr([Notes],"<div>")-1)],instr([right([Notes],instr([Notes],"<div>")-1)],"</div>")-1)
I might off-base and unrealistic.

pdx

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums