Hi Kjell,
In the Repoprt Designer, right click on the field. Choose "Properties". In the Format field, choose the Expression button (the one with three dots). In that dialog, ensure that the format is 9,999 or whatever is appropriate. Do not use quotes. Also ensure that the "Numeric" is selected in the optiongroup immediately under the Format field.
>>
>>Check the properties of the control you're using to enter the value & look at InputMask & read the help there. You can define the length of the value to be entered & it'll also allow you to enter the 1000 seperators.
>>
>> Andy Crawshaw
>
>I can still not get any separators in numeric fields on a report. It doesent matter what I write in the format dialog in the report.
>
>//Kjell
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05