Thanks so much. You guys are awesome. If only Microsoft would bend to my will!
"Peter Jamieson" wrote:
HI Laurel -
Yes. the problem is with the length of the number (as I suggested in the
previous thread - you can take this kind of approach up to around 14
digits). I don't think any of the other formula field suggestions made there
will help either).
In addition to the other workarounds I suggested...
---------------------------------
If the account number is more complex there are two things you can do other
than transform your data source into another format:
a. use a DATABASE field - nasty, but see http://tips.pjmsn.me.uk/t0004.htm
b. use Word VBA to issue a SQL query to get the data from the .csv file,
and put the necessary right() function in that query. That isn't
straightforward either, but it can usually be done as long as the .csv can
be read by the Jet ODBC driver/OLE DB provider and doesn't have more than
255 fields.
---------------------------------
....you may also be able to use the 16-digit kludge described in the "Number
fields" section on Graham Mayor's page at
http://www.gmayor.com/formatting_word_fields.htm
(I'm not sure if it is workable in the situaiton you describe)
Peter Jamieson
"Laurel" wrote in message
...
Hello All,
I'm using the x picture item to the display the last 4 digits of my field
which is a 16 digit number. The documentation says "Drops digits to the
left
of the "x" placeholder. If the placeholder is to the right of the decimal
point, Word rounds the result to that place."
Word is rounding my number even though there is no decimal. Is this
because
the number is so large? If I use a smaller number it doesn't round. I
tried
to solve the problem by using the INT(x) function but that didn't work. Is
this a bug?
I appreciate any insight or help can you give.
Thanks,
Laurel