Set format property to textbox in report

[holgar]

Hi,

I can't set this property in report design because fields can change depending of users choice (a listbox with field names from query).

I tried google but couldn't find anything about this.

 

[THWatson]

holgar
It's not clear what exactly you are trying to do. Can you describe the problem a little more?

Tom

 

[holgar]

I would like to format some of the textboxes to show to decimals instead of report showing whole (fix) numbers.
In report it shows
234
12,23
I want
234,00
12,23

Because I dont know where textboxes witch have to be formatted will be placed I can't use standard formatting in design view.
In the meantime I figured this

If Me.txt1 = Format(Me.txt1, "##") Then
Me.txt1 = Format(Me.txt1, "0.00")
End If

end it works fine without error.
But the problem is that there are some fields witch I don't want to apply formatting to.

 

[THWatson]

holgar
You can put custom format number fields up to four sections. This works either in a form or a report. In the Format property for the control put, for example...
$#,##0.00;($#,##0.00);"Zero";"No value"

This example works as follows...
First section is for positive numbers
Second section is for negative numbers
Third section is for zero values
Fourth section is for Null values

Beyond that, I'm still not clear where you are doing. Are you suggesting that a particular control in a report might sometimes be numbers and sometimes be text?

Tom