Subject Re: numbers as text
From Lee Grant <camilee@nospam.comcast.net>
Date Tue, 8 Apr 2025 02:40:58 -0400
Newsgroups dbase.getting-started

Charlie,

That should work, but how are you doing this and what version are you
using?  By how are you doing this, I mean are you entering the
format/picture code in the designer, or directly in the code without a
designer?

I ask, because if you use any other formatting symbol, the @R must be
the last code.  For instance, in one of my programs, I have the
entryfield having the text centered in the entryfield and also,
formatted for time, and the code in the editor looks like this:

       picture = "99:99"
       function = "I@R"

As you can see, the @R must be the last function code put in, so if you
have any other picture or function code going in, the last one need to
be the @R. I did this with dBASE 2019, but this should be the same for
earlier version, as far as I know.

Only other reason, I have to ask. Is that number formatting too large?
Billions? Really?

Hope this helps.

Lee

On 4/7/2025 2:18 PM, Charlie wrote:
> I have numbers as a string.  Might have asked this before but forgot.  I want to only use commas when user is working with them in entryfields or grids. .  Otherwise store them in the table as a string with no commas.   Using entryfields I have tried function @R 999,999,999,999 with no luck.  Can this be done without showing the commas on blank fields?