This is so basic and I am so uneducated in Access, but I have a program and I am trying to type in a number that may have one, two or three digits after the decimal point. I changed it from a number field to a text field thinking that would help, but it doesn't. I can't have it fill in with 0s because that changes my diagnosis code if you have additional numbers that are not really there. Can someone help with very simple instructions. I know it's not difficult, I'm just not sure how to do it....Thanks, Robin
8  1191 
We all started somewhere !
If I'm getting this right (and I hope I am) you need to have the text box formatted as a NUMBER
Then you want to be able to type in .123 rather than 0.123?
If this is the case I don't think Access will allow it as it has to have a preceed the point with something to have a the correct format.
even if you format the record in the table properties to DECIMAL and the scale as ZERO it will still put the pre point zero in for you
why is not haveing the points preceeding zero important?
Gareth
We all started somewhere !
If I'm getting this right (and I hope I am) you need to have the text box formatted as a NUMBER
Then you want to be able to type in .123 rather than 0.123?
If this is the case I don't think Access will allow it as it has to have a preceed the point with something to have a the correct format.
even if you format the record in the table properties to DECIMAL and the scale as ZERO it will still put the pre point zero in for you
why is not haveing the points preceeding zero important?
Gareth
Actually what I need is a 0 following the decimal point. Some codes are 236.30 others are 236.3 but they mean different things. So, I need the option to have the 0 showing if I type it in. Does that clarify things??? Thanks, Robin
i'm somewhat new myself, but you might wanna try changing the data type to a DOUBLE and set the number of decimal places. Also, if you're working in currency, i believe their is a data mask for that specifically.
in this case it depends...
changing it to a texxt box can help if ure typing everything in yourself. If so then i believe a text box would be more beneficial then any numerical field you would have in there since with a text field it reads it as is; however, with a numerical field 1.23 is the same as 1.2300000000. so how exactly are you using this data?
On the format of the tex box use &
That will allow any character including numbers.
I am trying to type in a number that may have one, two or three digits after the decimal point. I changed it from a number field to a text field thinking that would help, but it doesn't.
You say that changing the datatype to text "doesn't" help, but you've never actually said what kind of problem you're having to begin with! If these are ICD-9 codes, or something similar, there's no reason for them to be defined as numeric data. While they're composed of digits and "decimals" they will never be used in mathematical calculations. Defining them as text allows you to have the trailing zeros you need without Access lopping them off!
Welcome to TheScripts
Linq ;0)>
I will try again to identify them as text but when I tried that it still dropped the trailing 0 I needed. Yes, some of these are ICD-9 codes for diagnoses so the additional digits after the decimal including 0 is essential.
I appreciate all the responses and will try again. Thanks for your help!!
You say that changing the datatype to text "doesn't" help, but you've never actually said what kind of problem you're having to begin with! If these are ICD-9 codes, or something similar, there's no reason for them to be defined as numeric data. While they're composed of digits and "decimals" they will never be used in mathematical calculations. Defining them as text allows you to have the trailing zeros you need without Access lopping them off!
Welcome to TheScripts
Linq ;0)>
You need to recheck the relevant fields in the table for datatype. If the field is defined as text it makes no sense for any characters, zeros or otherwise, to be "dropped!" Trailing zeros are only dropped when they are the "decimal" part of a numeric datatype!
Linq ;0)> Sign in to post your reply or Sign up for a free account.
Similar topics
by: taquito |
last post by:
I just started to learn C. This is a very simple question, so please forgive me for posting this here.
I have a set of data in, let's say, .txt file. this txt file is in tab-delimited, like
1 4...
|
by: Bruno43 |
last post by:
Hi I am trying to learn Visual Basic and I am getting everything for the most part, mainly because of my ability to read code like a book, but my question is what is the best way to Navigate through...
|
by: kamikaze04 |
last post by:
Hello.
I have a very newbie question about Streams. The situation is that i have a function (that i cannot modify it's definition/call):
public void F1(istream & in){
while( ...) {
...
|
by: Banibrata Dutta |
last post by:
Hi,
I've gone through the list of "language differences" between 2.3 / 2.4
& 2.5 of CPython. I've spend around 2 weeks now, learning v2.5 of
CPython, and I consider myself still very very...
|
by: idiolect |
last post by:
Hi all - Sorry to plague you with another newbie question from a
lurker. Hopefully, this will be simple.
I have a list full of RGB pixel values read from an image. I want to
test each RGB band...
|
by: ckkwan |
last post by:
My VS2008 just arrive.
One very dumb question, how to subscribe to event like Page_Init?
I can't find it anywhere in the IDE. Ended up have to type in myself.
TIA
|
by: mcl |
last post by:
Why can I not the change the value of a variable in another class,
when I have passed it via a parameter list.
I am sure I am being stupid, but I thought passed objects were Read/
Write
eg...
|
by: Ethan Furman |
last post by:
garywood wrote:
^-- *not needed*
~Ethan~
|
by: jch |
last post by:
Sorry for the newbie question but I'm trying to learn Visual Studio. I've
got VS Express 2008 and I'm using visual basic. I'm trying to learn how to
deploy a program so I've written a very basic...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
