Format text in reports (1 Viewer)

[ATB]

HI

I have a simple report with a text box simalar to this,

= "You owe me" & " " & "[ammount owed] & "please pay it"

The trouble is the curentcy field is not formating correctly. I have chacked the formating of the query and this is OK. Is there a way to format the field wihtin the test box.

Thanks

 

[IMO]

Open the report in design mode and right click the field to format , goto Properties and change the Format field to Currency.

IMO

 

[ATB]

If i change the propoties of the text box to currency it interfears wiht the text in the box but chnages nothing for the number fields.

The text above is all listed wihtin a text box.

Thanks

 

[IMO]

Not quite sure what you mean. Can you post a stripped down version of your db and I'll have a look for you.

IMO

 

[IMO]

Has this field got text in it, or just a number?

IMO

 

[ATB]

text too.

 

[IMO]

That's why it wont work. You'll need an extra field (set as a number) in the underlying table just for the £ amount.

IMO

 

[ATB]

I have a query called say Q_invoice

This query contains a field called say [ammount due] which is a currency field and displays OK in the query.

I have based a report on the query and added a text box which contains this text.

="you owe me" & [ammount due] & "please pay"

when i open the report this displays:

you owe me 456.9899 please pay

I want the number to be formated in currency or at least as only two decimals.

The DB is too large to send.

 

[ATB]

I have a seperate field in the table and query, I simply just want to call this from the text box on the report to allow for the text to flow around the changing field ammount.

Cheers

 

[IMO]

You could try this:


= "You owe me £" & " " & "[ammount owed] & "please pay it"


IMO

 

[ATB]

Thats exactly what i do have!!

my question is how do i format the field to return the value to 2 decimal places or in curenncy

 

[IMO]

In the table make sure that is a currency field, not a number, and set the decimal places to 2

IMO

 

[ATB]

this is as you say. The field displays OK in the table and query.

Do you know how to format the feild from the text line?

 

[IMO]

See if this helps

IMO

 

[Rich]

="you owe me" & Format([ammount due] ,"Currency")& "please pay"

 

[ATB]

Rich, you are indeed a genious.

Thanks you so much for coming to my rescue, It worked a treat.

Regards

Graham