[AccessD] Freeze panes

Set the  display mode to  Datasheet mode.
Select the columns, shift+ right click and select "Freeze columns"
Save the Form.

If you want to make sure it is always that way:

Private Sub Form_Load()
personname.SetFocus
DoCmd.RunCommand acCmdFreezeColumn
companyname.SetFocus
DoCmd.RunCommand acCmdFreezeColumn
End Sub

-- 
Stuart

On 18 Feb 2012 at 8:49, Rocky Smolin wrote:

> Dear List:
>  
> I have a client who wants a list of persons and companies on a form, and
> following the person name and company, wants several other fields. All the
> fields won't all fit on the display, so a horizontal slider bar is OK to see
> the fields hidden off to the right off the screen.
>  
> However, he would like the person name and company name not to slide off to
> the left as he slides to the right - similar to the Freeze Panes function in
> Excel.
>  
> I haven't really thought about a technique to do this, but maybe there's
> some standard way to do this -  yet another Access function that I don't
> know about?  Or someone like Lebans has already done it?  Has anyone done
> this before?
>  
> MTIA
>  
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/> 
> www.e-z-mrp.com <http://www.e-z-mrp.com/> 
> Skype: rocky.smolin
>  
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>