Subform won't display as Datasheet View in Design Mode

[BlahBlahBlah]

As the title says, I'm trying to get a subform to display in datasheet view in design mode. I've tried:

• Setting the subform's Default View to Datasheet in design view whilst viewing the subform directly (and, to be sure, viewing it from within the main form).
• Setting Allow Form View, Allow PivotTable View and Allow PivotChart View of both the main form and sub form to No.

I'm trying to do this in order to change the row height of the records in datasheet view. The records were imported from an Excel spreadsheet and contain carriage returns instead carriage returns and line feeds, which Access apparently requires. I want to ensure that I can have multi-line rows/cells in datasheet view before converting all the CRs to CR LFs.

Edit: It appears that multi-line rows in datasheet view is not possible. I'm still interested to know why I can't see the form in datasheet view in design mode, though.

Cheers.

 

[vbaInet]

As the title says, I'm trying to get a subform to display in datasheet view in design mode.

This just simply isn't possible. The Default View is designed for when the form is opened (or run) not when it's in its design state.

I'm trying to do this in order to change the row height of the records in datasheet view.

Open the form in Datasheet View and make your changes there then save it. The settings will be remembered for when you open it again.

I want to ensure that I can have multi-line rows/cells in datasheet view before converting all the CRs to CR LFs.

Edit: It appears that multi-line rows in datasheet view is not possible.

If you're having problems with multi-line, change the Text Format property to Rich Text and see if that works.

 

[BlahBlahBlah]

This just simply isn't possible. The Default View is designed for when the form is opened (or run) not when it's in its design state.

Open the form in Datasheet View and make your changes there then save it. The settings will be remembered for when you open it again.

I discussed having the subform as a single form rather than a datasheet view with co-workers, and they prefer it, so this is no longer an issue.

If you're having problems with multi-line, change the Text Format property to Rich Text and see if that works.

I did that and got this error:

The setting you entered isn't valid for this property.

An invalid condition was encountered by Access due to a value that you entered for a field or table property. Review the table for any changes which might be out of range or are not supported by the table.
Examine any changes that you may have made to the table and, if possible, revert back to a previous copy of either the database or the table to determine the differences in your settings.

This happened for more than 1 field.

 

[vbaInet]

Good to hear!

I forgot to mention that it only works on Memo fields. Change one of your field's datatype in the table to Memo and set the Text Format to Rich Text. Then remember to change the Text Format on the textbox as well. Test it on one of your textboxes and see if it works.

This article explains how to handle CRs from Excel into Access:

http://support.microsoft.com/kb/210372

Edit: Ah, I think Rich Text doesn't work on subforms from what I remember. Give a try though.