I have a simple report that displays some fields in a SQL Database.

 

I have one field where some records display text, whereas some are missing. I have confirmed that the records that are missing have a # character at the beginning.

 

What would cause these records to disappear? I assume the # makes them disappear, but I cant find a way to get the record to appear?

 

I have tried to truncate the # character, but the field still doesnt display??

 

Any ideas??