Downloaded Microsoft 365 Personal and still cannot create and then print mailing labels an Access database

If you are experiencing issues creating and printing mailing labels from an Access database after downloading Microsoft 365 Personal, it could be due to several reasons. Here are some troubleshooting steps you can consider:

1. Check for Errors: Ensure that there are no errors in your database that might be causing the issue. Sometimes, corrupted data or misconfigured settings can lead to problems when generating reports or labels.
2. Review Grouping and Calculations: If your report is grouped on multiple fields and includes calculations, this could cause issues. You might want to simplify the report by changing the grouping properties or removing calculations to see if that resolves the problem.
3. Update Microsoft Access: Make sure that your version of Microsoft Access is up to date. Sometimes, updates can fix bugs or issues that may be affecting functionality.
4. Check Permissions: Ensure that you have the necessary permissions to create and print labels from the database. Sometimes, user permissions can restrict access to certain features.
5. Test with a New Database: Create a new Access database and try to create and print mailing labels there. This can help determine if the issue is with the specific database or with Access itself.

If the problem persists, you may want to consult Microsoft support for further assistance.

References:

• No current record error when you print or preview a report in Access
• Access may stop responding when you try to create an MDE, ACCDE, or ADE file

Are you able to use any of the report wizards? How about form or other wizards? Do you have your Access file in a trusted location? Do you have similar issues if you start with the Northwind (or another) template? Do you have a default printer define in the Windows control panel?

You should be able to create a label report without the wizard by setting the number and width of columns and height of the detail section.

Personally I never use the label report wizard, but do as Duane described, and create a multi-column report from scratch. When designing the report the height and width of the detail section must be exactly the same as the height and width of the label, and the section's CanGrow and CanShrink properties should be False (No).

Rather than putting each address line as a separate control in the detail section I put a single deep text box control of fixed height and call the following function, first published by Microsoft many years ago, to concatenate the values into a single string expression with each line separated by a carriage return/line feed:

Public Function CanShrinkLines(ParamArray arrLines())
    ' Pass this function the lines to be combined
    ' For example: strAddress =
    ' CanShrinkLines(Name, Address1, Address2, City, State, Zip)
    Dim X As Integer, strLine As String
    
    For X = 0 To UBound(arrLines)
        If Not IsNull(arrLines(X)) And Trim(arrLines(X)) <> "" Then
          strLine = strLine & vbCrLf & arrLines(X)
        End If
    Next
      
    ' remove leading carriage return/line feed
    CanShrinkLines = Mid(strLine, 3)
  
End Function

The one drawback of this method is that it does not allow you to format the lines independently, so you could not show the city name in boldface for instance. If you want to show two fields on the same line, then rather than separating them with a comma when calling the function, you'd concatenate them, e.g.

CanShrinkLines(ContactName, Address1, Address2, City, (State + " ") & Zip)

The US includes the City, State, Zip on a single line so the usage would be:

CanShrinkLines(ContactName, Address1, Address2, City & ", " & (State + " ") & Zip)