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

 

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 <pdk444444@yahoo.co.uk>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

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.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___