UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Displayng Last & First Name On Form    
 
   
pclutts
post Mar 3 2010, 09:24 AM
Post #1

UtterAccess Veteran
Posts: 461
From: Austin, TX
I have a table that has a column for LastName and a column for FirstName. I have set up a pick list on a form so the user can select the appropriate name. In the properties of the ComboBox the row source is: SELECT [tblAE].[AEID], [tblAE].[LastName], [tblAE].[FirstName] FROM [tblAE] ORDER BY [LastName], [FirstName]. Once a name is elected by a user, I want the form to dislay the name as LastName, FirstName. Currently it only shows LastName. Can anyone show me how to do that please? Thanks in advance for any help.
Go to the top of the page
 
+
chungiemo
post Mar 3 2010, 09:33 AM
Post #2

UtterAccess Enthusiast
Posts: 71
QUOTE (pclutts @ Mar 3 2010, 02:24 PM) *
I have a table that has a column for LastName and a column for FirstName. I have set up a pick list on a form so the user can select the appropriate name. In the properties of the ComboBox the row source is: SELECT [tblAE].[AEID], [tblAE].[LastName], [tblAE].[FirstName] FROM [tblAE] ORDER BY [LastName], [FirstName]. Once a name is elected by a user, I want the form to dislay the name as LastName, FirstName. Currently it only shows LastName. Can anyone show me how to do that please? Thanks in advance for any help.


is that is the Combo box?? if so then set your combo box properties of "column heads" to 2 and "Column Widths" to e.g. 2cm;2cm

hope this helps

Mo/
Go to the top of the page
 
+
bng89
post Mar 3 2010, 10:37 AM
Post #3

UtterAccess Enthusiast
Posts: 76
An alternative to Mo's solution. If you only want 1 column with the format of Lastname, Firstname you can try this:

CODE
SELECT [tblAE].[AEID], [tblAE].[LastName] & ", " & [tblAE].[FirstName] AS FullName FROM [tblAE] ORDER BY [LastName], [FirstName]
Go to the top of the page
 
+
pclutts
post Mar 3 2010, 10:55 AM
Post #4

UtterAccess Veteran
Posts: 461
From: Austin, TX
QUOTE (bng89 @ Mar 3 2010, 03:37 PM) *
An alternative to Mo's solution. If you only want 1 column with the format of Lastname, Firstname you can try this:

CODE
SELECT [tblAE].[AEID], [tblAE].[LastName] & ", " & [tblAE].[FirstName] AS FullName FROM [tblAE] ORDER BY [LastName], [FirstName]


Thanks to both of y'all for the very quick replies. I used bng89's suggestion and it worked fine. Thanks again.
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 01:02 PM