Change subform from datasheet so it can be edited

[ChrisMore]

Hi,

I have a form with a subform and would like to change the subform layout from datasheet to tabular without having to redo the whole form, is this possible?

Thanks,
Chris

 

[ChrisMore]

Open the form in Design View. What does it look like? Change it however you want. If the wizard built the DS form, all the fields and labels will already be associated in the detail section of the form. If you built the form manually, you might have done it differently.

What I mean is my subform is datasheet and I would like to edit its appearance. Am I able to change it to a different format so I can edit it?

Thanks,
Chris

 

[ChrisMore]

Hi,

I have attached a couple of images to show you what I would like to achieve.

I would like to change the subform with the yellow background so the shading is similar to the subform with the red background. I used the form wizard to create both but selected Tabular for the red subform and Datasheet for the subform with the yellow background. I have now decided against a datasheet subform and would like to edit it so it has a yellow background, just like how the subform with the red background is shaded.

Is it possible to convert the datasheet subform to a format which is editable to achieve this without having to redo the whole form?

Thanks,
Chris

 

[arnelgp]

just create a Continuous form and add it to the "main form".
make sure that it's Position is in Front (Bring to Front) of the datasheet subform.
set its Visible property to No.

on your code you can set its visible property again to Yes.