[AccessD] Access Report - One field for one Customer is Missing

David McAfee davidmcafee at gmail.com
Fri Oct 11 14:05:07 CDT 2013


I tend to think Gary is correct.

I bet there is some stupid character that is in there that is preventing it
from showing up.




On Fri, Oct 11, 2013 at 11:43 AM, Rocky Smolin <rockysmolin at bchacc.com>wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list