~TMP showing up in my value list

[Tangier]

Hi All,

In my reports menu, I am getting a report that shows up ~TMPCP...

I have no idea why this ~TMPcp... is showing up in my value list.

When I try deleting it from the value list, it pops up again after I
save my changes.

Has anyone seen this before?

 

[Douglas J. Steele]

How are you populating the value list?

Have you tried compacting your database?

 

[Tangier]

How are you populating the value list?

Have you tried compacting your database?

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)










- Show quoted text -

It is populating by looking at the contents of the Report container.

How do I compact the database?

 

[Douglas J. Steele]

What version of Access?

For Access 2003 and earlier, it's an option under Tools | Database Utilities

For Access 2007, it's accessible through the Office button.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)



How do I compact the database?