Re: export text file error

you're welcome ;) happy to help

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com


Slice via AccessMonster.com wrote:
Sorry for not responding sooner, but thanks for the reply. I had already
tried that and it made no difference. I noticed that from the original file
that was imported/converted was a currency field, which somehow affected the
way the export wizard worked. I eventually was able to work around the
problem. Thanks again.

Slice

strive4peace wrote:

use the Format function instead of the format property of the query column

field --> strNumber: Format([fieldname],"000")

substitute
"000" for your format code

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com


I have built a query which includes formatting the amount field to return the
amount as a string. I use the export wizard on the query file and the wizard
displays the amount field as expected (leading zeros, no decimal). When I
complete the export and look at the export file, the file contains the amount
formatted as currency, but I need the field to be as a string. Need help
ASAP.


.

Relevant Pages

  • Re: Dmax showing value
    ... do you have code in the BeforeUpdate event of the record which would prevent the record from being saved when it is first started? ... MVP Microsoft Access ... remote programming and training ... field which I made a required field and since it has to be filed in the ...
    (microsoft.public.access.formscoding)
  • Re: Error Code 3048/64509
    ... Do you have multiple users? ... Does the code use currentdb? ... MVP Microsoft Access ... remote programming and training ...
    (microsoft.public.access.modulesdaovba)
  • Re: Report By Defined Dates
    ... MVP Microsoft Access ... remote programming and training ... klam wrote: ... Session End Date1 Facilitator1 ...
    (microsoft.public.access.reports)
  • Re: convert date to julian date
    ... MVP Microsoft Access ... remote programming and training ... Rabbit wrote: ... I would like to have an unbound control in a form that calculates the julian date from the date entered by the user in a bound filed, ...
    (microsoft.public.access.forms)