best way to line up text on a form?

[davidnewbie]

Hello,

I am currently trying to create a report of some rows from a query on a place it on a form (it's based on data from the main form). I am currently appending text into a label.. There has got to be a better way to do it, but i heard you cannot use a sub-report on a form, I would like to get the text all lined up -- for example:

Date Time |col1|Col2 |col3 | col4|Col5----------------------------------------------10/01/08 18:43| IN| CHS002| 1234| DH|10/23/08 09:36|OUT| CHS002| 1456| DH|222 any ideas?.. is it best to stick all the data into a sub-form?

 

[CyberLynx]

Use a SubForm in Continuous Form mode. You can make it look just like a report if you like.

.

 

[davidnewbie]

Thanks, trying that.. if I change the "default view" on the subform to "continuous forms", it doesn't seem to have an affect. It always shows up with the datasheet view when displayed.

Also, if I were to just use the datasheet view, it seems to have column headers that have down arrows next to the column header names -- is there a way to get rid of these?

 

[CyberLynx]

It will look like a Datasheet if you are basing your SubForm from a Table Or Query when using the SubForm Wizard.

Create a new Form. If you use the Form Wizard then based the Record Source from your Table or Query.

Open the new Form in Design View.

Place Labels into the Form Header which will describe the columns of data.
Delete the Labels for the Controls within the Details section of the Form. Shape and align your controls to the Top of the Details section of the Form directly under your Labels. Snug all the Section Bars up tight against your controls then save your Form. Name it whatever you like but put Subform at the end of the name so that you know what the Form is for.

Now place a SubForm Control onto your Main Form. The Wizard will automatically appear. Within the First page of the Wizard, Select the Use an existing Form... option then select your newly created Form.

Finish the Wizard then run your Main Form. You can align and size your controls within the SubForm Form to provide the look and feel you desire. You an also add Conditional Formating to your Controls so as to provide additional enhancements.

.

 

[davidnewbie]

thank you for your help. I am currently sticking with the datasheet type view for now.