469,331 Members | 1,861 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,331 developers. It's quick & easy.

MS Access fields in Form mode

I am using MS Access 2003 and working in Form mode. Everything is working well until I come to a particular field and when I enter data it copies through to the same field in all records because I have 'Unbound' the field so that I can enter more information/data. If I bind the field then I can only enter a small amount of information/data.

I need to have different data in the field for each record. And, I need to have lots of information/data in each field and, it doesn't matter whether I am working in Table or Form mode - the result is the same.

I have looked closely at another database and have closely copied the properties to no avail.

What am I doing wrong?

Cheers, SANDRA4006
Oct 23 '06 #1
1 1142
MMcCarthy
14,534 Expert Mod 8TB
You cannot attach an unbound control to a record. If your only problem is space then create a memo field. This can store up to 64 kb of data.



I am using MS Access 2003 and working in Form mode. Everything is working well until I come to a particular field and when I enter data it copies through to the same field in all records because I have 'Unbound' the field so that I can enter more information/data. If I bind the field then I can only enter a small amount of information/data.

I need to have different data in the field for each record. And, I need to have lots of information/data in each field and, it doesn't matter whether I am working in Table or Form mode - the result is the same.

I have looked closely at another database and have closely copied the properties to no avail.

What am I doing wrong?

Cheers, SANDRA4006
Oct 23 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Megan | last post: by
1 post views Thread by Harry Devine | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.