By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,955 Members | 1,793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,955 IT Pros & Developers. It's quick & easy.

MS Access fields in Form mode

P: 2
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
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
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.