New Record In Table=Meaningless symbols in text field in Report

[MarkAccess2013]

I have an issue that is driving me nuts!

The short question is: When I add ANY record to a Table I get symbols in a Text Field on my Report. How do I fix this? The details are below:

I have a Microsoft Access Database of College Football Teams and their Schedules that otherwise works just fine. In the past, I regularly added new teams to the Teams Table. I enter Team Name, Conference and Division affiliation (if any), whether or not they play home games on Grass or Turf and a hyperlink to the team's website.

This week, I went to add Fordham to my Teams Table, as Fordham plays at Temple this week. After I entered the information in the Table, I saved and ran the Compact and Repair Database tool. I went to run a Report that contains a text field called "Comments" that I enter non-indexed comments about the game manually in the Schedule Table or on a Form. Not all games have comments. However, as a result of entering Fordham in the Teams Table, I now get nothing but weird looking symbols that look like Wing-Dings or Chinese Script in the Comments column on the report. These symbols show up in each row under Comments, whether or not I actually have a comment in the field. These symbols also show up on the report no matter what team or time period I select on the Form that runs a Query that generates the Report. Fordham does not have anything to do with the results (I first noticed it when I ran a report detailing the history of Wisconsin and Arizona St.).

I isolated the problem to this addition of Fordham, because if I delete the Fordham record from the Teams Table, Save and Compact and Repair the Database, I can return to the normal looking text in the Comments Text Field in the Report. I tried only entering "Fordham" as the team name, disregarding any of the other information, like Conference, Division, playing surface or (most importantly) the hyperlink, but I get the same symbols. I also tried entering just a team name of something other than Fordham, but the same pesky symbols show up. I restored a previous version of this database before the problem showed up, but, when I added Fordham, I got the same result. I tried searching on this topic, but with little luck. There were a few things like making sure the hyperlink was not indexed or Unicode Compression was off, but nothing really more than that.



Any help in determining why when I add ANY record to a Table I get symbols in a Text Field on my Report would be greatly appreciated.

[TG_W]

Did you create the database in Access 2013? If not, something from the version you created in might be causing the quirk. I only have 2010 at work, but tonight I can check to see if there is an option to convert up to Access 2013 like there is for Excel, Word, etc. Or you can check for that now.

[MarkAccess2013]

TG-Yes I did. My solution was that LongText=Memo Field in 2013. When I was having the issue, I did not realize LongText was a Memo field. Once I changed to ShortText my problem was solved.