Freeze Left Titles in Access 2003?

[whdyck]

Maybe a dumb question, but . . .

I have a subform in datasheet view containing data that fills more than the default-sized form. The left-most column contains Unit Numbers of vehicles in a fleet. When the user scrolls to the right, additional data displays for those vehicles. Is it possible to freeze the first column when the user scrolls right, so that the additional data on the 2nd screen shot displays alongside its corresponding Unit Number?

Basically, can Access freeze left titles, similar to a spreadsheet?

I see it can be done in Access 2010, but is there a way in Access 2003?

Thanks.

(Cross-posted to UtterAccess)

 

[bastanu]

Yes, select the columns and right-click then select Freeze.

 

[MajP]

Are you certain this was not available in 2003? From the internet it shows this feature was available in 2003.
https://msdn.microsoft.com/en-us/library/office/aa195906(v=office.11).aspx
You can fake this with two continuous subforms and a scrollbar control. You can also kind of fake it to have the column move as you scroll across by using the columnorder property. But checks to see if this capability exists.