Format from numeric fields

[Elsje]

Hi all,

I use Access as database and CR9.

In CR9 I have added numeric fields from my access tables. The problem is the following you can specifie how you want to display the number. But I want that it is always displayed in 3 digits. (for example 10 becomes 010) Is there a way to do this.

My second problem is that I want to rotate certain fiels 180°. I found a place where a I can rotate a field but you can only choose between 0-90-270.


Thanks in advance
Elsje

 

[lbass]

If the field is a number, you can use:

totext({table.number},"000")

If it is a numeric string, use:

totext(val({table.string}),"000")

I'm not aware of a way to rotate to other degrees.

-LB

 

[Elsje]

If I understand this correctly I have to use an formulafield. Is there not a way to do this directly on the field that I have added from my database.

Elsje

 

[lbass]

I'm not aware of any other way to do this.

-LB