I gotta right to sing the blues sheet music
You can't (I think) hide the column titles in a datasheet view... However, you can set them to " " (i.e. without text). If the subform is an actual form (Access 97), then set the label associated with each control to " ". If the subform is just a datasheet, open the recordsource, display the field properties and put " " as Caption. Combo Box Filter. Access 2000 - 2003 (Also OK for 2007 and later) This tip will show you how to create a Combo Box Filter i.e. only having values that can be selected in a second Combo Box, depending on the value of the first Combo Box APPLIES TO: ACCESS 2007, 2010 (UNTESTED IN EARLIER VERSIONS) The following tutorial shows you how you can use VBA to lock or unlock a text box on an access form following the update of another text box or after the click of a button. Lets assume we have a MainForm named "Orders" form and a SubForm named "Items" SubForm. To export MainForm data with SubForm, Select the MainForm report from the Reports tab. From the "Column Properties" option enable the "Link" button displayed for the SubForm, as shown in the screen-shot below, and click "Create" to update the changes. Using related combo boxes in the detail section of a continuous form can cause problems. Unbound combo boxes will show the same value on every row, and bound ones may mysteriously turn blank when they lose focus. This happens if a dependent combo box has a displayed column that isn’t also its bound column. 36. Freeze rows and columns 37. Clear worksheet panes 38. Change the chart style 39. Change the chart type Access 2016 Tasks: 1. Open a database 2. Close a database 3. Start Access 4. Create a blank database from a template 5. Save and name a database object 6. Change the font for a datasheet 7. Open a table in Datasheet view 8.