Selasa, 15 November 2016

Re: [MS_AccessPros] Field in Form being treated a text when it is numeric


sounds like you have identified my problem!
I might have to live with the form working correctly as far as data input is concerned but not being able to use it for filtering on that particular field.
thanks as always for your help. 

On Tuesday, 15 November 2016, 17:46, "John Viescas [MS_Access_Professionals]" <> wrote:


Is the Row Source of the combo box filtered?  And are you changing the Row Source when the user selects a value in one of the columns?  That could be the problem.  Remember there is only ONE copy of each control in a datasheet or continuous form view, so if you change the Row Source, it changes for ALL rows.  If you have a row that contains a value not in the newly filtered list, it will go blank.  The workaround is to do a tricky overlay of a text box on the combo that displays the value for that row no matter the Row Source of the underlying combo box.  I described how to do this as far back as my Running books.  It's not easy.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)

On Nov 15, 2016, at 6:05 PM, Phil Knowles [MS_Access_Professionals] <> wrote:

it's very odd - if I simply scroll down the records to the first one that I know contains a value in this field, the field appears blank but if I put my cursor in the field the value appears and in fact all the values that I would expect to see in the other records also appear !!!
if I move the cursor into the same field on a record that doesn't have a value in it all values disappear .
I have a requery command set in the on enter property of this field so it must be something to do with that

On Tuesday, 15 November 2016, 16:41, "Phil Knowles [MS_Access_Professionals]" <> wrote:

ok that will be fine but even though some records have values for this field they do not appear in the list to select and filter by and if I choose one of the sort options I would expect the records with values to appear at either the top or bottom but they don't appear at all
yet if I select the records that I know contain the values in this field (by filtering on another field) I can see the values in the field quite clearly 

On Tuesday, 15 November 2016, 16:29, "Phil Knowles [MS_Access_Professionals]" <> wrote:

Hi John
It is a new field and I have only  put values in this field for a few records.
It is a field though that gets its numeric value via a query and in fact displays the related description for that value rather than the numeric value itself - is that why it is confused?

On Tuesday, 15 November 2016, 15:43, "Phil Knowles [MS_Access_Professionals]" <> wrote:

I am using a form in datasheet mode and one o the fields is numeric.
normally if I select the box at the top of a text field it says 
sort a to z 
sort z to a
text filters 
then it gives me a list of all the values that are contained in that field with a check box to be able to select and filter
if I do the same for a numeric field it says
sort smallest to largest
sort largest to smallest
number filters
then it gives me a similar list to above
I have a field that is numeric and contains integers
but when I select the box at the top it displays the text version of events and doesn't give me a list of values 
any ideas why?


Posted by: Phil Knowles <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (10)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.



Tidak ada komentar:

Posting Komentar