U
Ulrich1947
Hi all,
I have a listbox within a form which is called everytime I need it by a
command button. Calling it, it receives it's rowsource by an SQL Statement
"SELECT num, IDkürzel, IDnr, Name, GRP, PLZ, Ort, Strasse, Kontakt FROM
(adrNAMEN LEFT JOIN adrADRESSEN ON adrNAMEN.num = adrADRESSEN.refNAME) LEFT
JOIN adrKONTAKT ON adrNAMEN.num = adrKONTAKT.refNAME WHERE GRP<>'aaa' ORDER
BY IDkürzel, IDnr;". This works fine.
In this routine a also change the forecolor of the listbox to a light blue.
This also works fine with one exception: Column PLZ (which is deriving from
table "adrADRESSEN") stays plain black. I wish, I could do this on purpose,
but in this case I do not want it.
Anyone knows why this happens ?
The only thing I could imagine is, that is has something to do with the
formatting of the PLZ field in the original table: "@@ @@@".
I'd be much obliged for help. Thanks
ulrich1947
I have a listbox within a form which is called everytime I need it by a
command button. Calling it, it receives it's rowsource by an SQL Statement
"SELECT num, IDkürzel, IDnr, Name, GRP, PLZ, Ort, Strasse, Kontakt FROM
(adrNAMEN LEFT JOIN adrADRESSEN ON adrNAMEN.num = adrADRESSEN.refNAME) LEFT
JOIN adrKONTAKT ON adrNAMEN.num = adrKONTAKT.refNAME WHERE GRP<>'aaa' ORDER
BY IDkürzel, IDnr;". This works fine.
In this routine a also change the forecolor of the listbox to a light blue.
This also works fine with one exception: Column PLZ (which is deriving from
table "adrADRESSEN") stays plain black. I wish, I could do this on purpose,
but in this case I do not want it.
Anyone knows why this happens ?
The only thing I could imagine is, that is has something to do with the
formatting of the PLZ field in the original table: "@@ @@@".
I'd be much obliged for help. Thanks
ulrich1947