I am using Windows 98 and Access 2k2. The problem is that i want to set the format property of a text-box to
##,##,##,##0.00 which is a bit different from the usual ###,###,##0.00 so that 123456789 is displayed is 12,34,56,789.00 and not as 123,456,789.00.
If i set the format property manually in design view or in VBA, it doesn't work as it is converted back to standard format (###,###,##0.00)
If i use input mask property it shows extra spaces and commas though it should not.
I don't wan't to use a calculated control. please help me out.
##,##,##,##0.00 which is a bit different from the usual ###,###,##0.00 so that 123456789 is displayed is 12,34,56,789.00 and not as 123,456,789.00.
If i set the format property manually in design view or in VBA, it doesn't work as it is converted back to standard format (###,###,##0.00)
If i use input mask property it shows extra spaces and commas though it should not.
I don't wan't to use a calculated control. please help me out.
