Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

List box not showing record correctly

Status
Not open for further replies.
L1sta

L1sta

Technical User
Feb 22, 2007
14
GB
Hi
I have a field in a table which has the format 'V99999'. When i call this in a list box the number appears without the 'V' (i.e. 12345 instead of V12345).
Is there any way to get the V to appear in the list box?
Cheers,
Lista
 
Sort by date Sort by votes
There are a number of ways, probably the easiest is to alter the Rowsource:

[tt]Select "V" & FieldName As VName From TableName[/tt]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
573
Kennelbloke
Kennelbloke
monkeysee
  • Locked
  • Question
Combo Box - Limit results
Replies
1
Views
368
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
482
dhookom
dhookom
visitnag
  • Locked
  • Question
combo box entries problem
Replies
8
Views
315
visitnag
visitnag
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
1K
JanaLNelson
JanaLNelson

Part and Inventory Search

Sponsor

Back
Top