Jump to content

letters and numbers


This topic is 8494 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.... smile.gif

Thanks!

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

Yeti

Link to comment
Share on other sites

This topic is 8494 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.