I have an Access 2000 list box on a form with 5 fields - 3 string and 2 numeric. Data source is a query combining 2 tables. Default alignment is left. I need to retain left alignment of the string data and right align the numbers.
In Access 2000, using VB, I can loop thru fields with sequential names in a table using variables, but having difficulty doing the same with textboxes on a form.
Example with table field names A1, A2...A20
dim n as integer
dim f1 as field
for n = 1 to 20
set f1 = rst.fields("A" & n)
f1 =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.