Hi - Beginner here - I have added a new column to my Access table and now I need to populate the entire column with the character "1" in each cell of the column. When I select all of the cells or the column and paste . . . it only pastes the first cell and leaves the rest blank. If anyone can tell me the formula/procedure I need in order to paste a same-text column I'd really appreciate it. --Retropost
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do you paste same text into Access Column?!
- Thread starter retropost
- Start date
evilmousse
Programmer
set the textbox's recordsource as
= "1"
fyi, you could also get that 1 in there within
the query.
select blahblah.., '1' as onecolumn, blahblah
from blah....
-g
= "1"
fyi, you could also get that 1 in there within
the query.
select blahblah.., '1' as onecolumn, blahblah
from blah....
-g
- Status
Similar threads
- Locked
- Question
- Locked
- Question