How to add spaces to text in a field?

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

Guest

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
 
Try this

left(FieldName,3) & " " & mid(FieldName,4,3) & " " & mid(FieldName,7,3) & "
" & right(FieldName,3)
 
Thanks, Ofer. Worked great!

Ofer said:
Try this

left(FieldName,3) & " " & mid(FieldName,4,3) & " " & mid(FieldName,7,3) & "
" & right(FieldName,3)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Expression 5
Text manipulation in update query 2
EXTRACT PART OF STRING DELIMITED BY SPACES 4
Searching a string for to find a matching substring 1
Query comparing non-identical fields 1
Parsing text in a field 3
Limit Text displayed in Combo box 4
concatenate entries from a column into a cell by logical AND withanother column 2

Back
Top