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