Display XXX before and after the numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

i am trying to disply XXX befoe and after any number in the report, examble

this number 24,544.22 should appear XXXX24,544.22XXXX Is there any
function do that

Thanks
 
Hi

i am trying to disply XXX befoe and after any number in the report, examble

this number 24,544.22 should appear XXXX24,544.22XXXX Is there any
function do that

Thanks
Click to expand...

3 X's or 4?
Use an unbound text control.
Set it's control Source to:
="XXXX" & [NumberControlName] & "XXXX"
 
add a textbox control to the report. in the control's ControlSource
property, enter

="XXXX" & [NumberFieldName] & "XXXX"

substitute the correct name of the number field, of course. if the number
value is not formatted the way you want in the result, try

="XXXX" & Format([NumberFieldName], "Standard") & "XXXX"

hth
 
Back
Top