[AccessD] Access 2007: Lookup Field Shows Correct ValueSelected, But Not Displayed

In the table properties...how many columns are in the rowsource of your 
lookup...and what are your column widths?

Thanks,

Mark A. Matte



>From: "Charlotte Foust" <cfoust at infostatsystems.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Access 2007: Lookup Field Shows Correct 
>ValueSelected, But Not Displayed
>Date: Mon, 16 Jul 2007 08:06:01 -0700
>
>Opening a data view of an action query may not display anything useful,
>if that's what you're describing.  Or do you mean that you ran the query
>and got zeros instead of 8s?
>
>Charlotte Foust
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gale Perez
>Sent: Sunday, July 15, 2007 7:22 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Access 2007: Lookup Field Shows Correct Value
>Selected,But Not Displayed
>
>Hello,
>
>I'm normalizing a db to replace certain fields with lookup fields.  I
>used the lookup wizard and am storing an autonumber from the lookup
>table.  All updated just fine, except for one.  The old field is a text
>field consisting of the numbers 0-7.  I created a query to update the
>new field (in the example, 8 is the autonumber PK in the lookup table):
>
>UPDATE mytable SET mytable.newfield = 8
>WHERE (((mytable.[oldfield])="7"));
>
>But when I opened the table to verify the new field's data matched that
>in the old field, I saw that the new field showed nothing but zeros.
>When I clicked in that field of a particular record, my dropdown box
>appeared, with
>the correct value selected - but it is not being displayed!   What the
>heck
>is going on?  Has anyone else had this happen?
>
>I tried re-creating both the query and the field, and got the same
>results.
>
>Thank you very much for any thoughts!
>Gale
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Need a brain boost? Recharge with a stimulating game. Play now!  
http://club.live.com/home.aspx?icid=club_hotmailtextlink1