report data dispay

[iovv]

Hi! I need to display data in report in the specific way - i've got a number 123456 and it should be visible as
12-345-6. Problem is that my goal is to get a txt file WITHOUT spaces so i put all the data in one field in my report - and now don't know how to set this - because it's imposible to set it with FORMAT field in Properities. Is there any other way to get a .txt directly from access without using all this reporting stuff? As you can see i have no idea about using VB

 

[Remou]

Have you looked at Export on the file menu?

 

[iovv]

Of course - but it has many problems with national captions - that's not the main goal after all. Main problem is makeing the raport to dispaly those digits with "-" signs. Source looks like this :
="R|" & [label1] & ", " & [label2] & ", " & [label3] & [label4] & ", " & [label5] & "|1111111|11-22-333|||" & [label6] & "|XXX|" & Date() & "|Text1|Text2|Text3|" & [label7] & "|" & [Label8] & "||||N||"
and .txt looks like this:
R|label1,label2,label3label4,label5|1111111|11-22-333|||label6|XXX|20-02-2007|Text1|Text2|Text3|label7|label8||||N||

Problem is LABEL8 -its a number and its stored by access and shown by report like 111122223333 and i need it shown like 1111-2222-3333

any suggestions?

 

[Remou]

In your original post you say:

Is there any other way to get a .txt directly from access without using all this reporting stuff?

Have you now decided to go with a report after all?

 

[iovv]

as i said - most important for me is getting those numbers with "-" - easy conv. it to .txt is not. Now i'm sending it to MSword and it make's me a txt from it with all national captions.

 

[Remou]

I did not quite catch that. You can use an Input Mask in the report to give the appearance you want:

####\-####\-####

 

[iovv]

I want a report WITOUT spaces so the only way to do this i know is to put all the Source into one field - and that means that i can't use input mask in "preferences"

 

[iovv]

OK found the solution - thanks for help anyway.

I put in the rocord source an exp:
Format([Label8],"@@-@@@@-@@@@")