|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 4th, 2004, 02:53 AM
|
|||
|
|||
Initials from NAME FIELDS
Access 2003
Can I restrict the output of a NAME field to print only the FIRST LETTER, i.e., the INITIAL? Or do I have to create a separate Initial field? 
|
|
#2
December 4th, 2004, 02:57 AM
|
|||
|
|||
|
How about
=Left([Name],1) Do you realize that Name is a poor Name for a field (or any other object) since every object has a name property. -- Duane Hookom MS Access MVP -- "MSMERRY" wrote in message news  Access 2003 Can I restrict the output of a NAME field to print only the FIRST LETTER, i.e., the INITIAL? Or do I have to create a separate Initial field?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Automatic filling of fields in table two from table one | Jim Kelly | Database Design | 1 | September 27th, 2004 10:16 PM |
| How do I import data to user-defined fields? | Bill at Ithaca HS | Contacts | 2 | September 17th, 2004 05:31 PM |
| Custumized Filter doesn't work in some fields | Jaime DomÃnguez | Contacts | 1 | September 16th, 2004 01:14 AM |
| SQL, merge fields and other mysteries | Geri | General Discussion | 1 | September 12th, 2004 12:38 AM |
| Import to custom fields in contacts | jdh | General Discussion | 1 | July 2nd, 2004 07:08 PM |
Linear Mode
