JustifyString function problem

B

Bob Howard

Hi,

I'm using the "JustifyString" function (from Stephan Lebans) to right
justify three columns in a ListBox. Two of them are working fine ... one's
a simple number (long integer) and the other's currency. The third causes
an Access 2003 crash!

That third column is a long integer which is a link to the autonumber field
in another table.

Both tables are in the query as I need columns from both tables in the
ListBox.

If I change the JustifyString to reference the autonumber field in the other
table, I still get an Access crash.

I didn't review the Access error report, nor did I have it sent to
Microsoft. At this point, I'm just trying to see if I have a blatant error
somewhere.

Is there something special about using JustifyString on such a field?

Is there something special about using JustifyString more than once or twice
in a single ListBox?

Bob
 
Top