letters and numbers

[Yeti]

On the invoice layout are number fields, for financial stuff.

I need to make these number fields accesible for letters (PM: Pro Memory).

I know this is not possible. I could change the numbers field to text, but then I'd loose the way numbers are displayed (Fl xxx,xx)

I tried placing wo fields on top of eachother, one text and one number field, but how do I make sure the number goes in a numberfield and text in an text field.

Or is ther another way to solve this?

Hope I made myself clear....

------------------

Yeti

[LiveOak]

I don't understand the "PM:Pro Memory" comment. Is this a program you are exporting to? What does "accessible for letters" mean? I need a higher level description of what you are trying to do.

Letters can be printed out of FM with appropriate formatting. -bd

[Yeti]

How things can be crystalclear for the writer but as dense as fog for the reader....I need to apologizefor the rumble I made.

I'll try again, so just forget my first scribbles.

I've got an invoice layout. Obviously I need fields to put numbers in (amounts of money). No problem yet.

But once in a blue moon we need to put owrds, or abreviations into those numberfields (pm = an abreviation for pro memory, meaning: not (to be) calculated).

But it's not possible to put text into nuberfields.

So how can I make field that will hold numbers as well as text?

Hope this clarifies things.

Ans again sorry for being foggy...

------------------

Yeti

[LiveOak]

How about making the entry field a text field, then have two stacked calculated display fields (format top one as transparent), one text and one number. They would be:

TextDisplay (calc, text) =

If(TextToNum(Entry) = 0, Entry, "")

NumDisplay (calc, number) =

If(TextToNum(Entry) * 0 , TextToNum( Entry), "")

You can format the number display field as $ 0.00 or whatever.

-bd

[Yeti]

Thanks for your reply LiveOak!

I tried what you suggested, at first no numbers showed up.

I left the *0 and it works like a gem!

This wouldn't be because any number multiplied by 0 makes 0....

Thanks!

------------------

Yeti

[LiveOak]

Oops! I forgot that the mac not equal symbol doesn't translate.-bd