Field Formating Problem using @;----

  • Thread starter Thread starter JasonM
  • Start date Start date
J

JasonM

I am using the expression @;---- to fill a blank entry in my reports with
four dashes. The problem that i now have with this is that I also would like
to display the numbers/text in the db in a certain format (I.E. XX.XX) I
have tried playing with various combinations but cannot seem to get what I
want.

Any suggestions? I would be very appreciative.

Thanks, Jasonm
 
If the format is always 2 characters, period, and two characters then try
@@.@@;----

You might have to use the \ character before the period, but probably not.
@@\.@@;----

The \ is used to say print the next character exactly as entered. So if you
wanted to have an @ added to the text you would need to enter \@@@.@@
 
John, Thanks for the suggestion... Unfortunately this doesn't work because
the valuse that I have stored are 12, 12.2, or sometimes 12.25 ... using
your suggestion I end up getting .12 and 11..2.

Do you have any other suggestions? This is one of those Nice to Have things,
not Have to Have... It will really make my report look a lot nicer and be
easier to read, but it is not an absolute requirement...

Thanks again for your input.

Jasonm
 
Nevermind... John, thanks again for your help, but I just didn't read into
the help file deep enough...

I found that using ##.##;;;---- did the trick I tried using ##.##;--- and
because it didn't work I assumed that this couldn't be done, but because
there were four possible formats for numbers I needed the extra two
semicolons!

Thanks again for the help.

Jasonm
 
Back
Top