Right Justificacion in textbox control conflicts with null values stored in recordsets.
Posted on 2003-11-10
I'm working with VB6 and SQL 7, with ADO. I have a form with a master table that allows the null value in some of the fields. And I have many TextBox controls to show thew info. Well, when I link the fields to the controls, I need the right justification to numbers, ok ? I do that as follows:
Set txtSpread.DataSource = rsAirplanes.DataSource
txtSpread.DataMember = rsAirplanes.DataMember
txtSpread.DataField = "Spread"
txtSpread.Alignment = vbRightJustify
And if I avoid the last line thew program runs with no problems, so how to do the justificacion but keeping the null values, of course ?
thank you very much for you atenttion.