(Msg. 1) Posted: Thu Jul 24, 2008 11:04 am
Post subject: Why do look up fields show numbers instead of text? Add to elertz Archived from groups: microsoft>public>access>tablesdbdesign (more info?)
I make a mounted equipment table and want to access it from the unit master.
access assigned id# to each brand 1 DuzMor, 2 Stetco, 3 BeauRoc etc.
When I use the dropbox to populate the field, it show number instead of
brand name.
How can I change this to reflect the name which is a better identification
method for users?
(Msg. 2) Posted: Thu Jul 24, 2008 11:42 am
Post subject: Re: Why do look up fields show numbers instead of text? Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Thu, 24 Jul 2008 11:04:01 -0700, John wrote:
> I make a mounted equipment table and want to access it from the unit master.
>
> access assigned id# to each brand 1 DuzMor, 2 Stetco, 3 BeauRoc etc.
>
> When I use the dropbox to populate the field, it show number instead of
> brand name.
>
> How can I change this to reflect the name which is a better identification
> method for users?
The table is correctly storing the ID number.
A table is for storing data, not for viewing, so the actual stored
value should not be of any concern.
To view the actual unit text, create a query.
Include the Equipment table and the Master table. Make sure there is a
relationship established between the 2 tables [ID] fields.
Then instead of adding the Master ID field to the query add the
Equipment text field.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
(Msg. 3) Posted: Thu Jul 24, 2008 2:28 pm
Post subject: Re: Why do look up fields show numbers instead of text? Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Thu, 24 Jul 2008 11:04:01 -0700, John
<John.RemoveThis@discussions.microsoft.com> wrote:
>I make a mounted equipment table and want to access it from the unit master.
>
>access assigned id# to each brand 1 DuzMor, 2 Stetco, 3 BeauRoc etc.
>
>When I use the dropbox to populate the field, it show number instead of
>brand name.
>
>How can I change this to reflect the name which is a better identification
>method for users?
On the Form you can set the ColumnWidths property of the combo box so
that the number field is in a zero-width column. It will still be
stored, just not shown. For example if your combo's rowsource query is
SELECT BrandID, BrandName FROM Brands ORDER BY BrandName;
you can use the properties:
ColumnCount 2
Bound Column 1
Control Source BrandID (or whatever the fieldname is)
ColumnWidths 0;1"
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office Other