• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 524
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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