Search results for query: *

I have the micr font and am able to use it in a text box but need to use a control box for the check number field and can't get the micr font to work with a formula that has text and numbers. Any suggestions?

Does anyone know how to use the micr font in a text box in a form that would combine the routing number with the check number on top of the check?

How can you delete the last 2 characters from a field?

Thank you! That worked perfectly!

How do you delete a certain text string (or if not that, then the last 6 characters of a field) using a query?

Go to View, Go to Background. Then reset margins there.

I would like the subreport to break to the next page when it gets to the bottom margin instead of staying together as a group onto the next page.

OK, sent. Thanks!

Ooops, sorry actually I had the subreport in there because I need the detail to show up twice, once on the upper portion of the letter and once on the bottom (because the recipient is supposed to tear off the bottom portion which lists the details again). Thanks!

Yes, I was using the subreport because my temporary fix was to format the subreport in 2 columns to use up more horizontal columns. It does not have to be a subreport as all the information is in the one query and I can just group them. I can email you the file if you think that would help. Thanks!

YES! Thanks! The query name is "Que StudentAwards" The field that is in the main report (LetterMainform) is "StudentID" The field in the subreport (LetterSubform) is "AwardName" This last field is the field that I want to display horizontally.

yes, that is exactly how it looks. I want it to look like this on a report Smith Award1, Award2, Award3 Jones Award1 I have seen your responses to other similar requests on this site and you usually type up a code which I have tried to copy without success. Can you do this without...

Scriverb, sorry, I am trying to string together text values (from a query) with a comma separating each record. I tried the module you posted above but got a compile error. Can you help? Thanks!!

I have the same problem. Columns do not work because the size of the entry in field is always different, it could be 5 letters or 50. Also, it is one field so you cannot concatenate.

I have a table that lists students' names and various awards that they got. For example, Smith has received Award1, Award2, Award3 and Jones received Award1. I want to produce a report that will list each award with a comma after it. I don't want it to be in columns or separate rows. How can I...