datasheet subform

S

Souris

I have a datasheet subform on my data entry form.
The column width is always set by Access which does not apply my data length.

Are there any way to customize the width of the datasheet subform?


Your help is great appreciated,
 
S

Stuart McCall

Souris said:
I have a datasheet subform on my data entry form.
The column width is always set by Access which does not apply my data
length.

Are there any way to customize the width of the datasheet subform?


Your help is great appreciated,

Open the form in datasheet mode (standalone, not as a subform), set all your
column widths, then explicitly save the form while still in datasheet mode
(if you switch to design view or just close the form, you'll lose all your
changes).

Then when opened as a subform it will retain your settings.
 
S

Souris

Thanks millions,


Stuart McCall said:
Open the form in datasheet mode (standalone, not as a subform), set all your
column widths, then explicitly save the form while still in datasheet mode
(if you switch to design view or just close the form, you'll lose all your
changes).

Then when opened as a subform it will retain your settings.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top