Re: Getting Rid of "Ghost Field" on Access Report

Thanks to Allen, Rick and Duane. I tried everything you suggested and could
not find the ghost. Even when I deleted most of the fields and controls, the
ghost field was still there. I ended up re-doing the report from scratch and
although it now works fine I never understood what caused the problem. Then
this afternoon I printed the original report (MyReport#1) and noticed that I
had done *conditional formatting* on a field and the ghost field was used to
determine whether or not to conditionally format. I missed that one because
it was not visible!!!!! Thanks again!!


"Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxxx> wrote in message
news:DE6F4CA1-DAF9-4B66-9D17-203B32F758C4@xxxxxxxxxxxxxxxx
You could try run the documenter against the report and see if the field
is
identified. I generally check:
-control sources
-grouping and sorting expressions
-link master/child of subreports
-filter property
-order by property
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


"Jorge Ramos" wrote:

Hello All,



I'm hoping you can help me with a puzzling behavior exhibited by an
Access
report. When I attempt to run it I receive an error message asking for a
value to a field that is not on the report or the underlying query.



I have a report, which I will refer to as MyReport#1. It runs off of a
MyQuery#1 without any error messages. I used MyReport#1 as the basis for
a
second repot, which I will call My Report#2. Everything, in MyReport#2 is
identical as MyReport#1 except for one field. MyReport#2 runs off of a
different query which I will call MyQuery#2. If I run MyQuery#2 by
itself,
it runs fine and does not produce any error messages. However, when I
attempt to run MyReport#2 I receive an error message asking for a value
to
the original field available on MyReport#1, but substituted for another
in
MyReport#2. I have unsuccessfully checked all the report fields searching
for an instance of the old field name. I've also searched the Sorting and
Grouping box but can not find a reference to the offending field. It is
almost like the report is asking for a value for the "ghost" field once
available on MyReport#1 but not present in MyReport#2.



Can you offer a suggestion as to what might be happening and how to fix
it?



BTW, I'm using Access 2003, SP3 running on Win XP



Thanks!






.

Relevant Pages

  • Re: Need LastName to CAPITALIZE
    ... I typed in your suggestion in the control source for the lastname on ... the report. ... I get an error message. ...
    (microsoft.public.access.reports)
  • Re: Can I Pass this Filter: ([Lookup_Field1].[Field1]="TYPE1"))) From Form to Report?
    ... I have tried the suggestion several ways, and every time I get the ... Of course RptStudyInformationDetail isn't a table but instead the name ... of the report on the open event? ...
    (comp.databases.ms-access)
  • set focus to report
    ... I want to move focus from one report ... I get an error message. ... a suggestion of how can move focus from one open report to another? ... M. Wilson ...
    (microsoft.public.access.reports)
  • Re: drivers maybe causing trouble
    ... move forward I need a copy of that Report. ... Disable automatic restart on system failure. ... Check for variants of the Stop Error message. ... for scanning for bad drivers. ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Error message
    ... I found an entry in bottom> section of "do not report errors for these programs" and> had one listed with a tick on it but the line was blank. ... Computer returned next day as it would power on>>and before windows would normally be on screen just went>>blank screen. ... >>I was then able to reboot the computer without any>>further error message on that day. ... Have looked in Event Manager and see a log>>of the errors and when they occurred reorts error in>>category 102 and event 1003 would presume this would>>relate to a device driver. ...
    (microsoft.public.windowsxp.general)