I inserted a new field and seems not linked to next number.

[leexiuxi]

Hi,
I am currently creating data set for survey entry.
One filed, which asking about year of born, got a problem.
Initially, I set the data type as Date/Time, but found that this type was not I wanted.
So, I changed to "Number" and set validation rule as "between 1900 and 2000".
After this, when I tried in forms, it automatically showed "1905" whatever year I entered.

I gave up to fix this problem and just deleted this row and inserted new row and also made new rule.
The other problem showed up which is that this field was no more connected to next number.
If I hit the enter in Year of born field, rather than move to next number, the page moved to next page.
I assume that the new inserted row is not connected to next number, but not sure how should I fix it.

So, I have two problems..
It would be great if any of these two problems can be solved.



Thanks!!

[rzw0wr]

I will make a few assumptions here.

The other problem showed up which is that this field was no more connected to next number.
If I hit the enter in Year of born field, rather than move to next number, the page moved to next page.

If this is the case, you will need to open the form in design view and select Tab Order at the top.
Select and drag the fields to what ever order you require.

The other problem you had was that you changed a Date type to a Number type and that data was in the field.
The number you got was what Access thought the field value was after the type change.

Dale

[leexiuxi]

Thanks! The "Tab Order" worked!!!

Just other question is, then do I need to delete every time whenever I want to change to other type?


Thanks,

[rzw0wr]

I do most of the time.
Access with try to guess what you are asking for.
Number to String is usually ok.

Date is the one that messes up the most.
Either changing from a date or to a date type.

Dale