Search results

Thank you Bob, I did not know that. When I saw the save button there I just clicked it automatically, from spending so much time in Word:)

Here is an image where I am saving it at....

It continues to truncate text beyond 255 characters. I can copy more text than that into the field but as soon as I click save it's gone!:(

Here is a snapshot of the properties for the field

I had an ampersand in the format field. I didn't put it there, it did it itself for some reason......

"Is your underlying recordsource for the form a QUERY by chance? Is this a bound form or an unbound form or are you doing this directly in the table?" I created a form that I believe is bound to the table but I'm not certain of bound and unbound. "You say when you click SAVE it does this...

It says Memo in the data type. when I copy text into the field any text after 255 characters is removed when I click save. I know it's 255 characters because I copied the remaining text into Word 2007 to do the count. It said 255 including spaces. In the properties I have an ampersand for the...

Is it possible to increase the size of a memo field to more than 255 characters:eek: Any suggestions would be appreciated... John

I'm not too much of an expert on access, but just pasting the Primary Key field will work fine. When I attempt to paste exclusively the primary key field I get the same thing, just a sequential list of numbers. So I created a new table and set the key field to "autonumber" and the field size to...

I have a table and I want to copy the Primary key, last name and first name fields but the primary key never copies over to the new table. All I get is a sequentially numbered list where I want to maintain the original Primary key IDs. Is it possible to paste the primary key field into the new...

I'm in access 2007. I don't have an edit menu and the selection option on the "Home" ribbon is grayed out in design view!

Is "line Control" a default setting? if so how do I disable it?

Can you tell me how I can determine that?

Hello everyone I'e been making reports and when I print them I can't get them to fit on one page only because Access is not allowing me to modify the row height by clicking on the detail band (with the double edged arrow) and moving it up or down. It stops where it wants to stop, not where I...

Thank you Bob, that's what I needed, I learned something new!:D

Thank you Bob, If that's the case I now have a new question. I need to flag a field in a report. I have two responses, Approved and Not Approved. How can I flag each repsonse as a different color in that field? All that I am getting is one option to modify the font in the whole field/Column. Is...

Is it possible to color code the entries in a lookup column? I attemted to modify the format after a lookup column was already created but it didn't change the color of the entries in the lookup column. I used: "Male "[Red];" Female "[Green] in the format section (in design view) after I had...

Can I upload it direcly to you Bob?

I'm not sure what an autonumber is but Access did not create these numbers. The numbers are unique identifications that are associated with each record. I used these IDs because they are the only field in any record that will be absolutely unique. This is a variation of the qustion I asked...

Hi everyone, I am using Access 2007 and I have a database with 2 tables. The original table has a primary key field designated. I have a relationship between that table and a second table and that relationship has "enforce referential integrity" checked. In the secondary table the field that...