Rocky Smolin
rockysmolin at bchacc.com
Fri Oct 11 13:43:52 CDT 2013
No S&G about it David. That's what I'd do next. Probably just delete the text box and re-create it. My cousin is a clinical psychologist. They have a saying "Whatever it is, that's not it." I find that's good advice in debugging something that makes no sense. We tend to unconsciously rule out stuff that couldn't possibly be the cause. Brad - how about deleting the record and re-entering it manually in the table? How about temporarily changing the data in the field that doesn't print to see if it's something about those particular bytes? R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee Sent: Friday, October 11, 2013 9:55 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access Report - One field for one Customer is Missing Could it be something silly like a field that is right aligned and excess white space at the end of that one customer field? can you put a label somewhere on the report for Sh|ts and giggles that uses the same control source as the suspect text box? On Fri, Oct 11, 2013 at 9:46 AM, Brad Marks <BradM at blackforestltd.com>wrote: > Rocky, > > Thanks for the help. > > I found an earlier version from the first part of September. I ran a > test with this version and the problem surfaced with this older > version also. > > I think that either the problem has existed for a long time and it was > never pointed out, or there is something really strange about the data > for this one customer. > > Brad > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky > Smolin > Sent: Friday, October 11, 2013 11:32 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Access Report - One field for one Customer is > Missing > > Do you have an earlier version of the mdb where the report does work? > If so, you could import that report into the current version. > > Rocky > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks > Sent: Friday, October 11, 2013 9:23 AM > To: Access Developers discussion and problem solving > Subject: [AccessD] Access Report - One field for one Customer is > Missing > > All, > > This is one of the strangest things that I have seen for a long time. > > We have a Sales Order report that has been used for several months. > Recently one of our users pointed out that the Customer Name was not > being shown for a specific customer. > > There are 7 fields shown for each customer on the report. All of the > fields are shown for all customers, except one. For this one > customer, only 6 of the 7 fields are shown. > > Here is where things get really interesting... > > When I look at the data from the underlying query, I can see all 7 > fields for this customer. > > In other words, all of the data is visible in the Report's data source > (underlying query), but not all of the data is being shown on the > report. > > Any ideas or suggestions would be appreciated. > > Thanks, > Brad > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > This message was scanned by ESVA and is believed to be clean. > Click here to report this message as spam. > http://h0stname/cgi-bin/learn-msg.cgi?id=B537727DED.DC8F0 > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com