'Hocus Pocus' Group's text fields disappear

[TommyK]

I've searched on disappearing data, but nothing fits my scenario.

I'm grouping on 'Item Number', i.e. all data with the same Item Number in one group. This group has a header, which displays the Item number and a description

then in the detail, dates, and order quantity.

Finally, in the footer the order quantities in the above detail are summed. When I open up the report in Report View, the text boxes which do the summing are blank, unless I click on the box, then the quantity shows. I have to click on each total box in each of the Item Number's group to reveal the total, i.e. what is in the text box.

What gives? When I created it last week, it worked. Now I have to keep clicking???



Any suggestions?

In Print Preview mode, the totals display, but I don't print this report. I just use this report to look-up the item data on the monitor.

[ranman256]

You SHOULD be looking at the report in print preview to view on screen.
When you print to actual paper, the boxes should also be filled in.

[TommyK]

While I COULD, and can, view in Print Preview, it's an extra step, a click actually. While it isn't much of an effort to perform an additional click it is an annoyance. That and if the data I am looking up overflows onto a new page in the Print Preview page, I don't have to click 'next page' ad infinitum (yet more clicks) I can just scroll down with my mouse wheel. It seems to be more intuitive to scroll down a bottomless 'page' when using the 'report' as a look-up screen. Too, the fields WERE totaling fine the other day. Now it is not. I was wondering if I had inadvertently enabled some prestidigitatorial magic that I could disable.

[ssanfu]

A couple of possibilities:
1) The Access gnomes are messing with you! (finally left me )
2) You have managed to find the hidden and undocumented "Mess With Me" button. Does all kinds of strange things....

Other than that, I have know eye deer. (<<= say it out loud fast)


Just curious (not judging), why won't a form work?
I have never thought of using the Report View to view data instead of a form. It is an interesting idea - food for thought.

[June7]

Possible corruption (by said gnomes?). Rebuild the report and see if issue persists.

[TommyK]

G-nomes it is! (pronounced gee nomes (my daugher has a G-nome project in her front yard. Big ones, little ones, fat ones, skinny ones))

After shutting down for the evening, then opening up the Accesss file the next day, the problem went away. Then it cropped up in another report! Then it cropped up in the original report!. We can blame this one on MicroSquarsh << This means I understood the "no eye deer" (which is synonymous with "no idy") in the previous post without the posted definition. I come from way south of Chicargo.

Logging out of and shutting down Access (no pc reboot necessary) seems to fix it for a time.

Using the report as a look-up screen comes from being from way south of Chicargo, where we look for better ways of doing things, not continuing to do things because that's the way we've always done it. I used to be "The Spreadsheet Guy", now I'm "The Database Guy". Why? Because if you can put it into a spreadsheet, it belongs in a database.