Question mark characters appearing in report?

[Meltdown]

Hi all,

I have a report where question mark symbols have started to appear in a report (see attachment).

In the Sql Server table I can also see a square symbol character, and I don' know where that is coming from either, anyone seen this before?

Regards
Melt

 

[RuralGuy]

Have you tried looking at your attachment?

 

[SOS]

What font are you using?

 

[Kiwiman]

Howzit

The "special characters" are possibly ascii characters. I don't know of a way to determine which one it is.

You may want to look at this site for a list - there are probably other sites

http://www.asciitable.com/

If it is an ascii character and you find which one it is you can use the Replace Function to get rid of it.

 

[SOS]

Howzit

The "special characters" are possibly ascii characters. I don't know of a way to determine which one it is.

My same thought - that's why I asked which font they are using so maybe looking at the character map we could figure out what is in there.

 

[Meltdown]

Hi, thanks for the replies.

From the ASCII chart it looks like Oct077 which is a question mark, except mine has a box around it.

I'm using Tahoma font, I've tried changing it, it's still there using different fonts.

Does anyone know how this has been created in the table?

Regards
Melt

 

[ryan2200]

I am having the same problem. Did anyone ever find the answer to solve this? Thanks.