1) The output in the record is = dun0424a.prt  I have to change the "." 

with "_" record will be        = dun0424a_prt" or save this record in 

other field



2) The output in the record is " dun0424a.txt " I want to change it by The 

output in the record as " dun0424a.rpt" renaming the extension name .rpt





Hope you can help me.



Thanks



Elmer 

If you're using A2k, see the Replace() function.



HTH,

-Roy



-----Original Message-----

From: Elmer Espinosa [mailto:elmerespinosa@y...]

Sent: Wednesday, May 02, 2001 12:47 PM

To: Access

Subject: [access] Inserting Underscore in in the record usiing Access

VBA







1) The output in the record is = dun0424a.prt  I have to change the "." 

with "_" record will be        = dun0424a_prt" or save this record in 

other field



2) The output in the record is " dun0424a.txt " I want to change it by The 

output in the record as " dun0424a.rpt" renaming the extension name .rpt





Hope you can help me.



Thanks



Elmer