Access Database 2007

Posted on 2013-10-17
Medium Priority
Last Modified: 2013-11-21
Error "You can't assign a value to this object"
*The object may be a control on a ready-only form.
*The object may be on a form that is open in Design View
*The value may be too large for this field

I keep getting the above error on the first entry of the day into a Access 2007 entry form.  When I click OK the field I'm trying to enter get's populated.  I've tried a couple of different fields, but regardless I get the same error.  I'm trying to develop this database for a client...this is my first Access Database, but I don't want to get the client something that will give them errors first thing.  Can anyone help me with this?
Question by:EASCOA
1 Comment
LVL 74

Accepted Solution

Jeffrey Coachman earned 2000 total points
ID: 39581326
You did not post any details, but this sound like you are string to insert something into a field or object, that it cannot accept.

For example, you are tying to insert a recordset into a Controlsource
Or you are trying to insert an image into a textbox
Or you are using code to inset/change a value, and your syntax is wrong.
...or it may be one of the things that is explicit listed in the errior...

So please post the code you are using, and state what line the error occurs on.

If it is not in the code, them please post a small sample database that exhibits this issue, ...and list the exact steps to replicate the error.


Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question