Gary Kjos
garykjos at gmail.com
Fri Oct 11 14:11:41 CDT 2013
We run into Tabs, New Lines and Carriage Returns amongst other things all the time in our data. A lot of times you can't seen them on screen in normal view. Sometimes you can see them in another font GK On Fri, Oct 11, 2013 at 2:05 PM, David McAfee <davidmcafee at gmail.com> wrote: > 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 > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com