Results 1 to 4 of 4
  1. #1
    Access_Novice is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Posts
    265

    Deleting rows deletes all columns in my report

    I am using Access 2013. I have a report in Layout View.



    1. If I right click on a single cell, then choose Delete, the entire column deletes, instead of just that cell. How do you delete only the cell?
    2. If I right click on a single cell, then choose Delete Row, all columns are deleted, instead of just that row. How do you delete only the row?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    What do you mean by delete a cell and delete a row? Why are you doing this in a report? Are you redesigning report or trying to delete records?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Access_Novice is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Posts
    265
    Quote Originally Posted by June7 View Post
    What do you mean by delete a cell and delete a row? Why are you doing this in a report? Are you redesigning report or trying to delete records?
    Yes. I created a report. Then I decided to delete a particular cell. In another case, I also decided to delete a particular row.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Access doesn't really have 'cells' and 'rows' on form or report, it has controls (textboxes, comboboxes, labels, etc). If you created the report with wizard, wizard 'groups' controls. In Design view, select all the controls with a left click and sweep, then right click > Layout > Remove. Now you can edit controls individually.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 12
    Last Post: 07-31-2013, 01:29 PM
  2. Replies: 1
    Last Post: 11-20-2012, 03:31 AM
  3. Deleting rows
    By ads8525 in forum Access
    Replies: 13
    Last Post: 02-10-2012, 08:52 AM
  4. Access Report deletes grouped data.
    By matt123 in forum Database Design
    Replies: 5
    Last Post: 07-07-2011, 09:19 AM
  5. Deleting empty columns from a table
    By kapil0712 in forum Programming
    Replies: 3
    Last Post: 05-17-2010, 12:35 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums