Force contents to the right of a query column.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I have changed my QryProducts to include a separate field for units, but I
want the position of the Units display to default to the right of the query
column. That is, right hard up against the RHS.

Please help, Frank
 
well, the general rule of thumb is that you don't expose query datasheets
directly to the user, same as table datasheets, and for the same reason -
you have little control over either the data or the user. suggest you
display the query's recordset via a form or report, when you can set the
alignment of the controls to suit your needs.

hth
 
I agree with Tina's thoughts. However, if you do want to display the query,
the Docmd.OpenQuery does have a parameter that will allow you to open the
query as Read-Only.

Example:
Docmd.OpenQuery "xx", acViewNormal,acReadOnly

Rob Mastrostefano


--
FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com
 
yes, that will protect the data, if that's the developer's wish; but it
won't help the OP to control field alignment as he asked about.

hth
 
Thanks, but this for a query for a combo box.


tina said:
well, the general rule of thumb is that you don't expose query datasheets
directly to the user, same as table datasheets, and for the same reason -
you have little control over either the data or the user. suggest you
display the query's recordset via a form or report, when you can set the
alignment of the controls to suit your needs.

hth
Click to expand...
 
well, the only way i can think of to control the alignment of a column in a
combo box "droplist", is to coerce the data type of the field in the
RowSource. but you can only use that in limited circumstances, and it's
fraught with potential problems. so the short answer is: there's no good
way to do it, AFAIK.

hth
 
Back
Top