Access 2000. I have table of many hundreds of records. One of th fields of text looks like this: XXXXXXXXXXXX and I want it to look like this: XXX XXX XXX XXX by adding the spaces. Would someone please show me how to write the function or code to add the spaces to the text as shown : Thanks :o

For those not wanting to waste their time, this cross-post has been asked and answered on another site.

For those not wanting to waste their time, perhaps you could provide a pointer to that other site.

Bob

Sorry, I felt it was the OP's responsibility.

http://www.dbforums.com/t1191291.html