Apend Query Problem Text Size

May 25, 2006

Hello - the world
this the 2nd time i tried this and hope someone can help

I have a form that i need to insert text into the text is held in a table and the amount of text can vary from 30characaters to 1,000's

now i have a drop down box with the following

SELECT [Wording].[wordingid], [Wording].[wordingnme], [Wording].[wording] FROM Wording;

i select one and then while that item is highlighted , i push a button append and it inserts in to my form

The table settings on the form are memo and the table settings on the wording are memo , i can see the info in the raw table its the append bit

so wording - fishing would be wordingnme and the text I want to apply would be "gone fishing etc "
works a treat but I only get the first 255 chars of a long wording

I can insert as many wordings into my form but size limt of 255 so its not the form

any ideas ?????:confused:

View Replies


ADVERTISEMENT

Can You Make Just One Part Of The Text In A Text Box Bold Or A Different Font Size?

Aug 20, 2004

Is there a way to make just part of the text in a text box bold, or to use different font sizes in the same text box?

Something like this:

---------------------------------
Heading in bold: description in regular (not bold)
(a smaller height line used as a line space)
Another "normal" line
a larger height line
a normal line....all in one text box!
---------------------------------

One thing I'd like to be able to do is to specify the line height of a blank line in a text box. I'm using carriage returns created with: Chr(13) & Chr(10). I could see defining the font size of a hidden character, but I'd need to know how to assign a font size to a piece of the text in a font box.

View 2 Replies View Related

Text Field Size

Jul 29, 2005

Is there any way of increasing a text field size to above 255?

View 3 Replies View Related

Text Field Size

Jul 11, 2007

MS documentation states that space is not reserved for unused characters in a text field. Does this mean that there is no storage penaly for having a text field 255 as opposed to 80.

On a more general note are there any tools to help calculate the size of a table?

View 4 Replies View Related

Label Text Size

Oct 4, 2006

Hello,

Is there a way to make the text in a label smaller than size 8?
I need to put some text on a form, but it's too large for the limited amount of space I have.

Thank you.

View 4 Replies View Related

Text Box Character Size

Feb 2, 2005

Hi all,

What can i put on a text box to limit the amount of characters entered like the 'field size' property for a table. I want to limit entry to 40 characters. Thanks in advance for any help,

M-.

View 5 Replies View Related

Type Text Field Size

Oct 2, 2006

Hi,

I have searched on this and it says: it doesn't matter as long as it's of type text. It matter if it's long integer..etc. I am not quite sure.

I wonder if default size '50 of fields' of type text occupies that size in memory even though the data in the field is not 50 chars.

Regards,
B

View 2 Replies View Related

Text Size For Colunm's In Subform

Apr 4, 2005

well, I have managed to get everything to work. Its a great feeling. the only thing I am having trouble with now is cosmetic.

http://www.lanschoolyard.com/newwindow.jpg
http://www.lanschoolyard.com/bar.bmp

Notice how the size of the text is a lot bigger than the size of the same text in the first image?

How do I reduce the size of the text? I have looked in all the boxes and tried everything but it just doesnt want to change the final output text size.

View 1 Replies View Related

Return Size Of A File In Form Text Box

Feb 17, 2005

A quick question that I'm sure one of you guys will be able to answer without any trouble, but I'm having difficulty with...

I have a form on which I would like to have a text box which returns the size of a file on my PC. The file path will not change.

Any ideas would be appreciated.

Thanks in advance.

View 1 Replies View Related

Reports :: Making All Text Box Grow The Same Size

Nov 17, 2014

I made a report that contains 10 textboxes beside each other and i changed the option (can grow) of the textboxes to yes the growing is okay, but i want all the textboxes to grow the same size as the bigger one.

View 5 Replies View Related

Forms :: Field Auto-size To Text In Form?

Nov 19, 2014

I am relatively new to using MS Access 2010. Some fields which i have set up as Memo fields to take report comments. Is there anyway to make the size of the memo field box variable to fit in with the text in the form when viewing in htis mode?

View 1 Replies View Related

Reports :: Text Within Report Labels Different Size In Preview / Print?

Jan 12, 2015

I have always noticed that when creating a report, when you make a paragraph using a label, the alignment and size of the text/paragraph is always different when you preview the report than when you design it.

This makes alignment of paragraphs tricky, especially when you are trying to insert a bold faced word into the middle of a block of text by using a separate label.

I am using Access 2000

View 4 Replies View Related

Changing Font Size Of Labels Depending On Text Length

Jul 28, 2014

I have a report that prints labels (similar to avery labels) which pulls data from a query. These labels are all unique and vary in length. Due to the length variance, I want the font size to get smaller for labels with more characters. I want the text to go down to another line when necessary.

In my report under the OnPage Event Procedure I wrote this:

Private Sub Report_Page()
If Len(Text2) > 20 Then Text2.FontSize = 8
If Len(Text2) > 10 And Len(Text2) < 21 Then Text2.FontSize = 10
If Len(Text2) < 11 Then Text2.FontSize = 14
End Sub

This works to some degree but the problem is that once there is a longer label, all of the proceeding labels are resized & the longer label that should have been resized was not.

Is there another place I should be writing this code? I looked under events for the textbox but there doesn't seem to be anything that would work since none of them would trigger when printing labels

View 3 Replies View Related

Import Text File / Multiple Lines And Varying Delimiters / Size To One Record

Aug 22, 2012

Using MS 2007, I have a 200 text files exported each day from another application that has two different types of lines (see below). I would like to import each text file in to a database as a single record.

Text file example (text.txt):

R111 WC 8/21/2012 7:00 Doe, John doej 10110110

First Question? Y
Second Question? N
Third Question? Y
...
Seventeenth Question? 10

As you see, I have the first row with multiple fields, but the next rows I have a question and an answer.

I would like to have this data imported as shown in the attachment. Example.zip

Most answers I see are for either multiple lines (same data and sizing). I am not sure how to handle several different lines with that vary in size and delimiters.

View 5 Replies View Related

Large Field Size = Larger Overall Database Size?

Aug 29, 2005

Will keeping your field size shorter result in a smaller MDB file?

Or does Access only use as much space as there is real data in its fields.

Way back in the dBASE III days, dBASE would pad all your "real" information with as many spaces as necessary to fill up your field. I suspect that the MDB structure is probably smarter than that.


Another question on the same topic - I believe there is a maximum number of characters in a record (4000?). Can your field sizes add up to more than 4000, as long as the actual data, all combined, never totals 4000...?
Thanks............
..dc

View 3 Replies View Related

Forms :: Text Size In Forms / Datasheets

Aug 16, 2014

I need to make the text size smaller to fit everything on the screen (users use 17" monitors..). I have gone into each form and subform and changed the text size for each text box to 9, but when I view them in form view the size has not changed ?

Also .. is there any way to make the autocentre option actually work as it's name suggests !! ? it does in most cases centre horizontally, but never vertically, quite often putting the top of the pop up form over the ribbon bar.

I would actually like to be able to totally remove the ribbon bar so that only the database forms are the only thing the user sees.

I vaguely remember being able to do this in Access 97 (Which was the last version I used - a long time ago !) but this seems to be more difficult in 2010 version.

View 5 Replies View Related

Query Question- Number Size

Apr 18, 2007

I code a field that shows different codes. Most of the codes are 5 digits but there are some in there that are 4 digits. What would I type in my query to just show the fields that have 5 digits.

View 3 Replies View Related

Getting DB Size Error When Running Query

Feb 12, 2013

I am modifying some queries in a DB which is only 411,000 KB. It still has plenty of room left before reaching 2GB. When I go through and test the queries, some run fine with no issues.Then I get to one of the last queries and get this error: "The query cannot be completed. Either the size of the query result is larger than the maximum size of a database (2 GB), or there is not enough temporary storage on the disk to store the query itself."

I still have about 1.5 GB of RAM available when this query is running, so it doesn't appear to be a RAM issue, and the DB still has plenty of room left to store the result set of this query.

View 4 Replies View Related

MDE File Size Growing And Query Rewritting Itself

Aug 29, 2005

I have a strange issue. First off I have a front end in Access 2000 as a MDE file linked to a mdb data file.

Issue number 1: The MDE file almost doubles in size daily. Yes, the mde file not mdb (it grows slowly and expectedly as data is added and deleted) . I expected the MDE file to stay a static size. Is this normal, what causes this?

Issue number 2: I had on 3 occasions a query in the mde file suddenly pop up with a ”cannot repeat table name ‘Nameoftable’ in FROM clause”. I go into the mde file, SQL query view and delete the extra table name and all is fine for awhile. After the second time I did away with that quey and rewrote the query for my form a different way. It’s come back once again now for anther table. Has anyone heard of Access doing this?

I also note that the modified date of the file keeps changing. I am wondering if someone is tampering. My client that has this software is very naïve.

The MS site has no information regarding either behaviour.

Any ideas?

Jim

View 2 Replies View Related

The Higher The Database Size, The Slower The Query Process?

Jul 10, 2007

I am developing a database and testing it with dummy data. With 50,000 records, the query process using SQL command is just OK. But if I double the total records, the query process takes longer time. The query is to make recapitulation using SUM of SQL command based on certain criteria. Any idea to make the query faster?

Thanks.

View 2 Replies View Related

Database File Size Getting Larger From Search Query

Apr 4, 2008

I'm having a problem with my database filesize getting larger with the more searches i do. At first i couldn't figure out how it was getting so big, but then i tried a few things and came to the conclusion that every time i do a search it increases its filezile.what made me notice this at first is that the file size of the original copy of my db is 13MB, but if i Save As a different name, like Assets_Backup, then the size of the new file is only 2MB, and after i do some searches it increases again.here is a file with just my search form and search query so you can see the code for them. i removed everything else to shrink the file down, which also made the search form not function properly, but i thought the design and code might be enough.is there something that i can change to keep it from remembering every search?thanks for any help.--------------------after searching the topic a bit more i've found that compacting the database will shrink it down to 2MB, but is this something that will have to be done on a regular basis, or is there a way for it to do it on its own?

View 5 Replies View Related

A Query To SELECT A Columen Within An Interval Which Conatains TEXT+DIGIT+TEXT

Dec 28, 2006

I have a column which contains "text digit text" as "AAA 222 BBB". The numbers of letters or digits can vary.

I need to SELECT the column which contains digits in a specific interval. For Example I have
"DFS 673 JKK"
"A 3454 LJLJ"
"SD 854 JKLJD"

I need to SELECT the column which contains 600 < Digit < 700 the result of the query in this case would be "DFS 673 JKK" because 673 is between 600 and 700.

Thanx for any clue or suggestion...

View 1 Replies View Related

Database Size Limited To 2GB / Query Multiple Database Without Linking Tables?

Sep 7, 2011

I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:

1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.

2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.

I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.

View 3 Replies View Related

Query Which Filters Text Typed In Text Box On A Form

Dec 4, 2013

So i have made a query which filters the text you type in your text box on a form. This is working great, but then this morning I had some records that contain some blank fields. My query does not show those records even if they contain the same text that I would type in my search form.This is my expression in my query of one column:

Like [Forms]![searchform]![Qprojectomschrijving] & "*"

View 7 Replies View Related

Text In Text Box As Criteria In Query.

Dec 10, 2006

Hi, How can I make the data in a textbox on my form automatically entered as the search criteria in a query. So say the box says Mike Johnson, can I make a command button (That I can eventually subsititute as the actual box) that puts the Nma emIk Johnson into a search query and brings up all the information on him from the database?

View 4 Replies View Related

DB Size

Sep 18, 2006

Hi,

What should be done when the size of a database keeps getting bigger and bigger?

Regards,
B

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved