Customize Datasheet View

[Ice Rhino]

I wish to create a subform that contains a subform that is made up of a query in datasheet view. I wish to be able to format the display properties of the datasheet though (Font etc).

The problem is that the result set is too wide and too big (out of scale with rest of form) and it just looks darn right nasty

Having looked through the sample form provided in Northwind they seem to have done it on the 'orders' form but I can not for the life of me work out how to do it.

Anybody?

Regards

 

[trucktime]

Subform

Instead of Datasheet use Continious Forms.
That gives you more control over display options.

 

[Ice Rhino]

Thank You for the input

I will try that now

 

[Ice Rhino]

How do I get the sub form looking like the attached ringed in red?

Thanks

 

[trucktime]

Form

If you can upload the mdb (without sensitive data) with the form I'll have a look at it and I'll be happy to adjust it for you.
That is probably the easiest way.

 

[Ice Rhino]

Thanks for the offer, but even stripped to its bear bones with no data in it exceeds the attachment limitations.

Kind offer though thank you

 

[trucktime]

Upload

Did you compact the database?

You could make a new empty MDB and import only the relevant (empty) table, query and the forms form the other one.

 

[Ice Rhino]

Please find attached a stripped version of the database. the table I wish to show on the sub form in a formatted datasheet view is tblArchive. Although ulitmately I want the information to be shown to be based around a Select query that will be filtered based on whatever the user has selected in some of the boxes on themain form. I can get it to do that, it is the main part of getting a user formatted datasheet view that is important at this moment in time.

Thanks for your help, look forward to the result

Regards

 

[rockman]

1) Close the main form.
2) Open the form that represents the subform ib datasheet view.
3) Choose Format->Fonts on menu.
4) Make changes.
5) Close the subform.
6) Open the main form (your changes should be reflected).

HTH,
Jeff

 

[Ice Rhino]

Thanks, I will try that