Report shows html code for only one user in shared database

I am trying to help my coworker. Their dept has an Access database that's on a network share. There is a report they run. For everyone else it runs fine. However for this employee, there is html/css coding in with the words (i.e. <div><font face=Arial>). They are all using the exact same database and report. I uninstalled and reinstalled Office but no luck. I can't find any settings that might affect that. Any ideas?

Screen shot is attached. I had to white out some of the info, but you'll see what I mean.
SDTSSAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
That indicates that the DB is using "Rich" text (really HTML),.
This only became available in Access 2007 and newer.

So my guess is that perhaps this odd user is still using Access 2003 or older?

Either that, or the user has modified the control's properties and set the "Text Format" property back to "plain text".
So check that it is set to "Rich Text"

Note that the "Text Format" property is a separate property form the "Format" property...


JeffCoachman
0
SDTSSAuthor Commented:
She is using 2010. I know she didn't do anything on purpose because she is a novice user, but she could have on accident. Since the report is located in the database on the share, wouldn't that property change affect everyone using it though?
0
Jeffrey CoachmanMIS LiasonCommented:
< Since the report is located in the database on the share, wouldn't that property change affect everyone using it though? >
Yes, but I did not know this when you posted the Q.
The database should really be split and each user will have their own Front end database (froms queries, reports) on their local machine...(preferably a mde or .accde file)
...and they will be linked into the Back end database (tables only) on the server.
See here: http://office.microsoft.com/en-us/access-help/split-an-access-database-HA010342026.aspx


Make sure all the machines accessing this DB are all up to date with the same Updates for Office AND Windows...
Run the compact repair utility.

Then report back to us...


JeffCoachman
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Jeffrey CoachmanMIS LiasonCommented:
<Report shows html code for only one user in shared database>
...well I guess you did mention it...
;-)

sorry about that...


...so try what I suggested and report back to us...

Jeff
0
SDTSSAuthor Commented:
It is split but both the front and back end are on a shared network drive. The computers are up to date. I'll try a compact and repair, but I'm not sure that will help. It has to be a setting or something on her computer either through her options/settings in Access or something else.
0
Jeffrey CoachmanMIS LiasonCommented:
<It is split but both the front and back end are on a shared network drive.>
That is not an optimal setup, ...but it does not matter here for this question. (so don't worry about it)
;-)

<It has to be a setting or something on her computer either through her options/settings in Access or something else. >
Not sure, I don't see any setting in Access or Windows that would affect this "Directly"...

Is this for all fields/controls?
Is this issue for just this one report  (for this user), or for all reports (for this user)?

JeffCoachman
0
SDTSSAuthor Commented:
That did not work.
0
Jeffrey CoachmanMIS LiasonCommented:
"That did not work."
...Please be specific.. What  exactly did not work...
In my last post I simply asked two questions :
    Is this for all fields/controls?
    Is this issue for just this one report  (for this user), or for all reports (for this user)?
0
SDTSSAuthor Commented:
The compact and repair did not work. It is for one field/control. This database only has one report.
0
Jeffrey CoachmanMIS LiasonCommented:
The only other thing I can suggest is to see what the font is for that control, on a good machine.
Then make sure this font is installed on this users machine...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SDTSSAuthor Commented:
The client was unable to work with me further unfortunately.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.