Formatting output to word (A2k)

Topic

New Reply

I’m probably doing this wrong, but it seems like Access isn’t listening. Here’s my code:

.ActiveDocument.Bookmarks(“SSN”).Select
.Selection.Text = Right(Format((CStr(Forms!frmStudents!SSN)), “@@@ @@ @@@@”), 11)

Here’s the result:

@@ @@ @@@@@

Any suggestions?

Reply | Quote

Replies

I figured it out. I’m guessing Access goes in order from right to left, so my information is being formatted first, then trimmed. If I add a @ to the beginning of my format (now looking like this: @@@@ @@ @@@@) it works.

Reply | Quote

Perhaps the SSN field contains @@@@@@@@@?

Added: by default, strings are formatted right to left. You can use ! in the format to specify that formatting should proceed from left to right.

Reply | Quote