Re-Format Text Field to Separate Fields on Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with a field called RESULT_CDE, it is defined as a text
field with 6 positions. This field can be left blank, or be filled with
numerical text entry of 6 characters. This table was converted from an old
DOS Based Fox Pro application to Microsoft Access 2003. Issue is that I need
to take the defined Text-field of 6 positions (example of 480791) and break
it down into an output field on a report of 48/07/91. I'm not strong on
direct visual basic code, and feel that its got to be done this way, but
unsure of what to code or how to code it. Any suggestions would be greatly
appreciated. Thanks In Advance
 
I have a database with a field called RESULT_CDE, it is defined as a text
field with 6 positions. This field can be left blank, or be filled with
numerical text entry of 6 characters. This table was converted from an old
DOS Based Fox Pro application to Microsoft Access 2003. Issue is that I need
to take the defined Text-field of 6 positions (example of 480791) and break
it down into an output field on a report of 48/07/91. I'm not strong on
direct visual basic code, and feel that its got to be done this way, but
unsure of what to code or how to code it. Any suggestions would be greatly
appreciated. Thanks In Advance
Click to expand...

Simply set the format property of the control to:
@@/@@/@@
or .....
In an unbound text control:
=Format([RESULT_CDE],"@@/@@/@@")
 
Back
Top