Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 514
  • Last Modified:

Total on datasheet view in strange spot

Please see attachment.

I can't figure out why the word "Total" is showing up in this strange spot on a form datasheet view.  Why is it showing up under "Shipped Y/N" and why can't I move it?

--Steve
Total-Screen-Shot.jpg
0
SteveL13
Asked:
SteveL13
  • 2
  • 2
1 Solution
 
Dale FyeCommented:
If you open the data sheet in design view, then go to the "home" tab on the ribbon,  you will see a summation symbol (sigma) at the top center of the ribbon.  Unselect that and the total row in the data sheet will go away.  Then save the data sheet when you close it.
0
 
SteveL13Author Commented:
That removes the total row.  But when I re-click on Totals the word "Total" comes back in the strange spot.

Plus in design view the Sigma symbol is grayed out.
0
 
Dale FyeCommented:
Sorry, I was working from my ipad and was working from memory.

By strange spot, do you mean that it is showing up in the 3rd column instead of the first?

Do you not want the datasheet totals line to show at all, or do you just not want to display the term "Total"?

You are correct, if you want to turn it off, you have to have the datasheet open in datasheet view (by itself, not as a subform).  Then you need to unclick the "Totals" option on the Records section of the "Home" tab.  Then you have to save the form before you close it.  Once you have done that, the Totals line will be gone, until you turn it on again.
0
 
SteveL13Author Commented:
Yes, I understand.  But the word "Total" keeps coming back in the wrong place.  I don't want it to be in the 3rd column but actually in the first column.  Is very strange.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now