ACCESS 2010 Can't delete filed from form.

Hi Folks,
I have a form with a filed that I changed from Text To ComboBox and created a Value List.  The field will not let me to:
- Update it with data.
- Change it back to a Text Box.  Access crashes.
- Delete the field from the form.  Nothing happens.

I have Compacted /Repaired and checked everything else I can think of to delete the filed so I can start over but to no avail.

At this point I just want to delete the field from the form without deleting the form and starting over.

Any ideas?

Thanks.
Bob C.
Bob CollisonSystem ArchitectAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bob CollisonSystem ArchitectAuthor Commented:
Hi Folks,
Sorry I misspelled Field as Filed in the question.
Sorry,
Bob C.
0
Rey Obrero (Capricorn1)Commented:
from VBA window do a DEBUG>Compile

correct any errors raised.

do a compact and repair

post back if you can delete or not the field.
0
Bob CollisonSystem ArchitectAuthor Commented:
Hi Rey,
As suggested I have:
- Done a Debug > Compile from the VBA Window.  No errors detected.
- Completed a Compact & Repair.
- Tried to delete the field from the form.  Can't delete it.

Thanks,
Bob C.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Rey Obrero (Capricorn1)Commented:
ok, try this. this command will save the form as a text file, "frmA" is the name of the form

application.saveastext acForm, "frmA", currentproject.Path & "\frmA.txt"

now rename "frmA" to "frmA_x"

import back the saved frmA.txt

application.loadfromtext acForm,"frmA",currentproject.Path & "\frmA.txt"

see if you can modify the newly loaded form

.
0
Dale FyeCommented:
Well, you don't really delete "fields" from forms, you delete controls.  Are you telling us that if you open the form in design mode, you cannot simply click on the control and then delete it?  Can you take a screen shot of the form and post it here?

You indicated:

"I have a form with a filed that I changed from Text To ComboBox and created a Value List.  The field will not let me to:
- Update it with data.
- Change it back to a Text Box.  Access crashes.
- Delete the field from the form.  Nothing happens."


So, you changed the textbox control on the form to a combo box, then you made the row source for the combo a value list.  Can you post the values in your Value list?  Why did you change it back from a combo box to a textbox?  Is the control still bound to a field in your forms RecordSource?  If so, is that field numeric or text?
0
Bob CollisonSystem ArchitectAuthor Commented:
Hi Experts,
Rey, I'm not sure where to complete your commands to try your solution.  Could you please let me know?

Dale, I tried to change it back because it wasn't working as a ComboBox / Value List field.  I e.  I could select the two values but only the 'MBR' value is accepted in the field.

I am attaching a DB containing the Form and associated Table.  The field I am having a problem with is the Data Type field.  Everything else appears to be working correctly.

The bottom line is that I need to select one of two values in the field and update the record.  If I can do that then I don't need to delete the field.  That was just an attempt to get the field to work correctly.

Thanks,
Bob C.
Remove-Field-From-Form.accdb
0
Rey Obrero (Capricorn1)Commented:
here is the form without the combo box
Rev-Remove-Field-From-Form.accdb
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bob CollisonSystem ArchitectAuthor Commented:
Hi Rey,
I was able to successfully add the field back into the form you supplied and convert it to a ComboBox / Value List.

Could you please let me know how you were able to remove the field.

Thanks.
Bob C.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

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.